REPLACE
Returns the string str with all occurrences of the string from_str replaced by the string to_str.
Syntax​
REPLACE(str,from_str,to_str)
Arguments​
| Arguments | Description |
|---|---|
| str | The string. |
| from_str | The from string. |
| to_str | The to string. |
Return Type​
A String data type value.
Examples​
SELECT REPLACE('www.mysql.com', 'w', 'Ww');
+-------------------------------------+
| REPLACE('www.mysql.com', 'w', 'Ww') |
+-------------------------------------+
| WwWwWw.mysql.com |
+-------------------------------------+