How to get only Digits from String in mysql?
<p>I have some string output which contain alphanumeric value. I want to get only Digits from that string. how can I fetch this by query? which MySql function can I  Use? </p>

<p>My query is like : </p>

<pre><code>select DISTINCT SUBSTRING(referrerURL,71,6)   
from   hotshotsdblog1.annonymoustracking   
where  advertiserid = 10 
limit  10;
</code></pre>

<p>Output : </p>

<pre><code>100683
101313
19924&amp;
9072&amp;h
12368&amp;
5888&amp;h
10308&amp;
100664
1&amp;hash
101104
</code></pre>

<p>And I Want output like :</p>

<pre><code>100683
101313
19924
9072
12368
5888 
10308
100664
1
101104
</code></pre>