title: How to get only Digits from String in mysql?
body: <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>