Search with Regular Expression in MySQL

Based on patterns regular expression is a powerful tool which gives you a flexible way to identify strings like email, IP address, phone number etc.

Use Regular Expression in Mysql:

For example, you want to find a name which starts with character A, B and C.

SELECT name
FROM users
WHERE name REGEXP  '^(A|B|C)';

Must Read:

• Learn Regular expressions in few hours
• SQl MATCH AGAINST find results with only more than 3 characters in the result