title: how to get number only from string field mysql
body: <p>I have field that has value kind of store878 . I would like to have 878 from select statement. How do I get that numbers from select statement</p>
  
  <pre><code> select 
       store,
       address 
   from 
       detail, 
       store_number 
   where 
       store (here i would like to have number) =  store_mumber.id 
  </code></pre>