title: MySQL REGEXP - Removing white space and non-numeric characters
body: <p>I want to do a search in a MySQL database for phone numbers.</p>
  
  <p>At present with this query:</p>
  
  <pre><code>SELECT person FROM people WHERE phone_number RLIKE '123456789'
  </code></pre>
  
  <p>It wont find:</p>
  
  <pre><code>(123) 456 789
  (12) 456789
  123 456 789
  etc etc
  </code></pre>
  
  <p>In my MySQL query is it possible to strip everything and just leave the numbers? </p>
  
  <p>I'd also like to search removing all spaces and just leaving the numbers and characters and also removing all characters and just leaving numbers and spaces. Not sure how easy all this is.</p>
  
  <p>Appreciate your help!</p>