<div>
Please find the link below , this may help you:<br />
<br />
<a href="http://ushastry.blogspot.com/2009/10/mysql-extract-numbers-out-of-string.html" rel="ugc">http://ushastry.blogspot.com/2009/10/mysql-extract-numbers-out-of-string.html</a>
</div>


Please find the link below , this may help you:

http://ushastry.blogspot.com/2009/10/mysql-extract-numbers-out-of-string.html [http://ushastry.blogspot.com/2009/10/mysql-extract-numbers-out-of-string.html]

<div>
let us know if you need any more clarification<br />

</div>


let us know if you need any more clarification


<div>
Will this clean the data? OR just select the data?
</div>


Will this clean the data? OR just select the data?

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have a column with telephone numbers where some fools have put in text and () insdie here. I need a script which I can run that will strip all this rubbish out. I will then need to put this script in a cron job...<br />
<br />
Thanks
</div>
</div>


Hi,

I have a column with telephone numbers where some fools have put in text and () insdie here. I need a script which I can run that will strip all this rubbish out. I will then need to put this script in a cron job...

Thanks

MySQL script to strip out non numeric

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.