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)';
- Learn Regular expressions in few hours
- SQl MATCH AGAINST find results with only more than 3 characters in the result