Search with Regular Expression in MySQL

MySQL SELECT

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:

For any types of queries, you can contact us on info@namasteui.com.

You may like:  MySQL Views

Leave a Reply

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