MySQL regexp_like() Function

MySQL regexp_like() function is used for pattern matching. It compares the given strings and returns 1 if the strings are same else it returns 0.

Syntax

snippet

select regexp_like(str1, str2);

snippet

select regexp_like('MCA', 'mca');

Output:

snippet

select regexp_like('MCA', 'bca');

Output:

Related Tutorial

1 MySQL Not Like Operator

2 MySQL Not regexp Operator

3 MySQL Regexp Operator

4 MySQL regexp_instr() Function

5 MySQL regexp_like() Function

6 MySQL regexp_replace function

7 MySQL regexp_substr() Function

Try it

Contents +