8/9 How do I replace enriched_flour for flour and have it right?


#1

8/9 How do I replace enriched_flour for flour and have it right?
I used the form:

SELECT
id, REPLACE(ingredients,'enriched_flour','flour')
as item_ingredients
from baked_goods;

And nothing worked


#2

SELECT REPLACE(ingredients, 'enriched_flour', 'flour') AS item_ingredients
FROM baked_goods;

made it for me...


#3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.