Learn
Another useful string function in SQL is REPLACE()
:
REPLACE(string,from_string,to_string)
The function returns the string string
with all occurrences of the string from_string
replaced by the string to_string
.
For example in baked_goods
, there is a column named ingredients
. The ingredients strings are formatted with underscores, such as baking_soda
and vanilla_extract
. To make these values more readable, we might like to replace the underscores with spaces. We can do so by using the following query:
SELECT id, REPLACE(ingredients,'_',' ') as item_ingredients from baked_goods;
Instructions
1.
Any time enriched_flour
appears in the ingredients list, we’d like to replace it with just flour
.
Apply this transformation and be sure to rename the column item_ingredients
.
Sign up to start coding
By signing up for Codecademy, you agree to Codecademy's Terms of Service & Privacy Policy.