REGEXP_REPLACE
REGEXP\_REPLACE(expr, pat, repl[, pos[, occurrence[, match\_type]]])
#Examples
mysql> SELECT REGEXP_REPLACE('a b c', 'b', 'X');
a X c
mysql> SELECT REGEXP_REPLACE('abc ghi', '[a-z]+', 'X', 1, 2);
abc X
Comments
REGEXP\_REPLACE(expr, pat, repl[, pos[, occurrence[, match\_type]]])
mysql> SELECT REGEXP_REPLACE('a b c', 'b', 'X');
a X c
mysql> SELECT REGEXP_REPLACE('abc ghi', '[a-z]+', 'X', 1, 2);
abc X