SQL Function Reference

REGEXP_SUBSTR

Returns the first substring from expr that matches the regular expression pattern. Returns NULL if no match is found.

MySQL

REGEXP_SUBSTR(expr, pattern)

expr

The string to search in.

pattern

The regular expression pattern to search for.

Examples

MySQL

SELECT member_name,
	REGEXP_SUBSTR(member_name, '(Andie|Quincey)')
FROM FamilyMembers;