How to get only digits from a string in MySQL?
00:56 17 May 2016

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?

My query is like : 

select DISTINCT SUBSTRING(referrerURL,71,6)   
from   hotshotsdblog1.annonymoustracking   
where  advertiserid = 10 
limit  10;

Output : 

100683
101313
19924&
9072&h
12368&
5888&h
10308&
100664
1&hash
101104

And I Want output like :

100683
101313
19924
9072
12368
5888 
10308
100664
1
101104
mysql sql