Code Editor
Click here to navigate the course.
Drag the edges to resize the window.
In Projects, you can keep track of your progress as you go throught the tasks. Check each item as you complete it!
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;