Quick
Ref.
Functions
- date
- number
- string
Data Types
- date
- number
- string
|
Compatibility
| REPLACE(f, s1, s2) |
| Engine |
OK |
Alternative |
| mysql |
yes |
|
| oracle |
yes |
|
| postgres |
yes |
|
| sqlserver |
yes |
|
REPLACEREPLACE(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 ''.
|
Results
|
See also: | |
