Syntax
REPLACE(str, from_str, to_str)
Purpose
You can call this function to return 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 (0.00 sec)