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.

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

Must Read:

For any types of queries, you can contact us on

You may like:  Maintaining MySQL Database Tables

Leave a Reply

Your email address will not be published. Required fields are marked *