我有一列成分,我想提取所有以“ed”結尾的成分。例如; 我有一份配料清單,如:
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
我想要一個正則運算式,它應該提取以“ed”結尾的完整成分字串,例如:
Cabin Fever maple flavored whiskey
Flamed orange peel
Cola Candied ginger
uj5u.com熱心網友回復:
SELECT * FROM ingredients i WHERE i.name LIKE ('
轉載請註明出處,本文鏈接:https://www.uj5u.com/ruanti/353197.html
