title: mySQL regex in the where clause
body: <pre><code>SELECT telephone_number
  FROM table
  WHERE telephone_number REGEXP '^1[() -]*999[() -]*999[() -]*9999$';
  </code></pre>
  
  <p>how do i make so its valid for any number format and any number
  like </p>
  
  <pre><code>407-888-0909
  1(408)998-7654
  7776654433
  876-7788
  </code></pre>
  
  <p>right now its only valid for 1-999-999-9999</p>