REPLACE

Compatibility

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

• SUBSTRING function
• LEFT function
• RIGHT function