i have a column of ingredients and i want to extract all those ingredients that end with "ed" . e.g; i have a list of ingredients like:

Dolin dry vermouth
Cabin Fever maple flavored whiskey
bacon strips
ginger ale
tequila
Eggnog*
Flamed orange peel
Amontillado sherry
White rum
Lemon wedge
Vodka
Fresh lemon juice
Triple sec
Silver tequila
Gin
Simple syrup
Cola, to top
Cola Candied ginger
Fresh lemon juice

I want a regex which should extract complete string of ingredient ending with "ed" like:

Cabin Fever maple flavored whiskey
Flamed orange peel
Cola Candied ginger

CodePudding user response：

SELECT * FROM ingredients i WHERE i.name LIKE ('