Function Reference
REGEXP_SUBSTR
Returns the first substring from expr that matches the regular expression pattern. Returns NULL if no match is found.
MySQL 8.1
REGEXP_SUBSTR(expr, pattern)expr
The string to search in.
pattern
The regular expression pattern to search for.
Examples
MySQL 8.1
SELECT member_name,
REGEXP_SUBSTR(member_name, '(Andie|Quincey)')
FROM FamilyMembers;