title: How to remove all the non numeric characters from column in mysql in bulk data
body: <p>I want to remove all the non numeric characters from the column. I have bulk data in my database.</p>
  
  <p>Currently I am using method as describe in below link:</p>
  
  <p><a href="http://venerableagents.wordpress.com/2011/01/29/mysql-numeric-functions/" rel="nofollow">http://venerableagents.wordpress.com/2011/01/29/mysql-numeric-functions/</a></p>
  
  <p>The problem is that its taking too much time for preocessing.</p>
  
  <p>For 1 million of row current logic takes 1 hour to process the data.</p>
  
  <p>please help me..</p>
  
  <p>Thank You,
  Ronak</p>