What if I want to clean the ingredients column?
SELECT REPLACE(ingredients,'enriched_',' ') as item_ingredients, replace(ingredients,'_',' ') as item_ingredients FROM baked_goods;
Tried this, but the result is 2 columns.
How to combine it into 1 column?
Or to manipulate many criteria of strings in a column?
Thank you in advance.