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);

Example 1

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

Output:

MySQL regexp_like Function

Example 2

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

Output:

MySQL regexp_like Function
Related Tutorial
Follow Us
https://www.facebook.com/Rookie-Nerd-638990322793530 https://twitter.com/RookieNerdTutor https://plus.google.com/b/117136517396468545840 #
Contents +