REGEXP_INSTR — MySQL 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 8.1

REGEXP_INSTR(expr, pattern)

expr

The string to search in.

pattern

The regular expression pattern to search for.

Examples

MySQL 8.1

SELECT member_name,
	REGEXP_INSTR(member_name, 'or')
FROM FamilyMembers;

MySQL 8.1

SELECT member_name
FROM FamilyMembers
WHERE REGEXP_INSTR(member_name, 'or') > 9;