SQL Function Reference

REGEXP_INSTR
Returns the position of the first occurrence of a substring matching the regular expression. Returns 0 if no match is found.
MySQL
REGEXP_INSTR(expr, pattern)
expr
The string to search in.
pattern
The regular expression pattern to search for.
Examples
MySQL
SELECT member_name,
	REGEXP_INSTR(member_name, 'or')
FROM FamilyMembers;
MySQL
SELECT member_name
FROM FamilyMembers
WHERE REGEXP_INSTR(member_name, 'or') > 9;