SQL Function Reference

REGEXP_REPLACE
Replaces all substrings in expr that match the regular expression pattern with the replacement string.
MySQL
REGEXP_REPLACE(expr, pattern, replacement)
expr
The source string.
pattern
The regular expression pattern to search for.
replacement
The string to replace the found match.
Examples
MySQL
SELECT member_name,
	REGEXP_REPLACE(member_name, 'incey$', 'een')
FROM FamilyMembers;
MySQL
SELECT good_name,
	REGEXP_REPLACE(good_name, ' ', '_')
FROM Goods;