title: mysql Group field name eliminating all non alpha characters
body: <p>i have a table with phone number entered as shown below </p>
  
  <pre><code>tel
  --------
  +6112345
  611-12345
  61112345
  611 12345
  </code></pre>
  
  <p>All these are one phone number which has been entered in different ways. How can I write a query which will group all these into one?</p>
  
  <p>I have written a query like -</p>
  
  <pre><code>select replace(replace(replace(tel,"+",""),"-","")," ",""), count(*)  
  from tb_orders 
  group by replace(replace(replace(tel,"+",""),"-","")," ","")
  </code></pre>
  
  <p>help me fix this please!</p>