Difference between revisions of "REPLACE"
From SQLZOO
| (One intermediate revision by one user not shown) | |||
| Line 27: | Line 27: | ||
<p>See also</p> | <p>See also</p> | ||
<ul> | <ul> | ||
| − | <li>[[SUBSTRING function]]</li> | + | <li>[[SUBSTRING |SUBSTRING function]]</li> |
| − | <li>[[LEFT function]]</li> | + | <li>[[LEFT |LEFT function]]</li> |
| − | <li>[[RIGHT function]]</li> | + | <li>[[RIGHT |RIGHT function]]</li> |
</ul> | </ul> | ||
Latest revision as of 15:22, 16 July 2012
| 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
