mySQL regex in the where clause

by

Use:

SELECT telephone_number
  FROM table
 WHERE telephone_number REGEXP '^1[() -]*[[:digit:]]{3}[() -]*[[:digit:]]{3}[() -]*[[:digit:]]{4}$';

Reference:

More Related Contents:

  1. How to do a regular expression replace in MySQL?
  2. MySQL Split Comma Separated String Into Temp Table
  3. MySQL strip non-numeric characters to compare
  4. How to extract two consecutive digits from a text field in MySQL?
  5. How to extract the nth word and count word occurrences in a MySQL string?
  6. How to remove all non-alpha numeric characters from a string in MySQL?
  7. How to count words in MySQL / regular expression replacer?
  8. #1139 – Got error ‘repetition-operator operand invalid’ from regexp
  9. Does MySQL Regexp support Unicode matching
  10. How do I refer to capture groups in a MySQL regex?
  11. MySQL SELECT LIKE or REGEXP to match multiple words in one record
  12. Is it Possible to Enforce Data Checking in MySQL using Regular expression
  13. How to regex in a MySQL query
  14. remove all numeric characters from column mysql
  15. How to use IN & NOT IN same query [closed]
  16. MySQL: Large VARCHAR vs. TEXT?
  17. Check overlap of date ranges in MySQL
  18. Multiple-column foreign key in MySQL?
  19. Get the latest date from grouped MySQL data
  20. UUID performance in MySQL?
  21. MySQL: NULL vs “”
  22. MySQL update a joined table
  23. Optimal MySQL settings for queries that deliver large amounts of data?
  24. mysql configuration stops at “starting server”
  25. What is the best way to delete old rows from MySQL on a rolling basis?
  26. mysql equivalent data types
  27. Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
  28. Using MySQL triggers to log all table changes to a secondary table
  29. MySQL search json value by key in array
  30. apache mysql – “packets out of order” on 3306

Leave a Comment