MySQL Function Reference

REGEXP_LIKE

Checks whether the string expr matches the regular expression pattern. Returns 1 if a match is found, otherwise 0.

MySQL 8.1

REGEXP_LIKE(expr, pattern)

expr

The string to test.

pattern

The regular expression pattern to search for.

Examples

MySQL 8.1

SELECT member_name,
	REGEXP_LIKE(member_name, '^An')
FROM FamilyMembers;

MySQL 8.1

SELECT good_name
FROM Goods
WHERE REGEXP_LIKE(good_name, 'fee');