Step 8/9: Replace enriched_flour with just flour

[antoninslejska]

I tried the following scripts:

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

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

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

SELECT id, REPLACE(REPLACE(ingredients,'enriched',''),'_',' ') as item_ingredients
from baked_goods;

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

SELECT REPLACE(ingredients,'enriched_','') as item_ingredients
from baked_goods;

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

SELECT REPLACE(REPLACE(ingredients,'enriched',''),'_',' ') as item_ingredients
from baked_goods;

But none of the scripts was accepted.

[leonhard.wettengmx.n]

@antoninslejska,
The required solution

SELECT REPLACE(ingredients, 'enriched_',' ') 
 as item_ingredients
FROM baked_goods;

####========================================================================

IMHO
the following would be valid, as the Instructions where unclear…

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

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

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

SELECT REPLACE(ingredients,'enriched_','') as item_ingredients
from baked_goods;

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

####========================================================================

The following select’s would lead to
brown_sugar becoming brownsugar

SELECT id, REPLACE(REPLACE(ingredients,‘enriched’,’’),’_’,’ ') as item_ingredients
from baked_goods;

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

SELECT REPLACE(REPLACE(ingredients,‘enriched’,’’),’_’,’ ') as item_ingredients
from baked_goods;

[sfinley17]

SELECT REPLACE(ingredients, ‘enriched_’,’’)
as item_ingredients
FROM baked_goods;

Is actually the correct response. There should be no space in between the ‘’. Otherwise, the entry would be ’ flour’ instead of ‘flour’.
But thank you @leonhard.wettengmx.n for pointing me in the right direction