SQL Function Reference

REGEXP_LIKE

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

MySQL

REGEXP_LIKE(expr, pattern)

expr

The string to test.

pattern

The regular expression pattern to search for.

Examples

MySQL

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

MySQL

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