Syntax
REPLACE(str, from_str, to_str)
Purpose
REPLACE() returns the str string with all occurrences of the from_str string replaced by the to_str string.
This function is multi-byte safe.
Examples
obclient> SELECT REPLACE('abc.efg.gpg.nowdew.abc.dabc.e', 'abc.', 'www');
+---------------------------------------------------------+
| REPLACE('abc.efg.gpg.nowdew.abc.dabc.e', 'abc.', 'www') |
+---------------------------------------------------------+
| wwwefg.gpg.nowdew.wwwdwwwe |
+---------------------------------------------------------+
1 row in set