Using Regular Expressions in MySQL Queries
Here is an example of how you would select data based on a regular expression.
SELECT phone FROM table WHERE phone REGEX '^[0-9 ]{11,14}$' = 0 LIMIT 100
The above would show all the phone numbers that are not between 11 and 14 numbers and spaces.
SELECT phone FROM table WHERE phone REGEX '^[0-9 ]{11,14}$' LIMIT 100
The above would show all the phone numbers that are between 11 and 14 numbers and spaces.
I hope this quick guide has helped.
Any questions, feel free to ask.
If you enjoyed this post, please consider to leave a comment or subscribe to the feed and get future articles delivered to your feed reader.
Comments
No comments yet.
Leave a comment