Replaces a string with another one.
\!h Format
REPLACE(string, from_string, to_string)
-- (location, string to replace, what to replace with)
\!h Example - replace all underscores with spaces, in the column 'ingredients'
SELECT id, REPLACE(ingredients, '_', ' ') as
item_ingredients
from baked_goods;