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;