DavidSzczesniak
1/25/2018 - 11:32 AM

REPLACE()

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;