REPLACE
From SQLZoo
REPLACE(f, s1, s2) | ||
---|---|---|
Engine | OK | Alternative |
ingres | Yes | |
mysql | Yes | |
oracle | Yes | |
postgres | Yes | |
sqlserver | Yes |
REPLACE
REPLACE(f, s1, s2) returns the string f with all occurances of s1 replaced with s2.
REPLACE('vessel','e','a') -> 'vassal'
In this example you remove all the 'a's from the name of each country. This happens because the string 'a' is replaced with .
SELECT name,
REPLACE(name, 'a','')
FROM bbc
See also