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
Return Type
VARCHAR
Examples
SELECT REPLACE('www.mysql.com', 'w', 'Ww');
+-------------------------------------+
| REPLACE('www.mysql.com', 'w', 'Ww') |
+-------------------------------------+
| WwWwWw.mysql.com |
+-------------------------------------+