title: How to extract only the numerical values from a column (varchar) in mysql?
body: <p>sorry if  it was asked before , but I couldn't find anything helpful. Using MySQL 5.7 , I've got  the column "Statistics" which has the following format {"Births:" 21678 }. How can I select only the numeric value ?</p>
  
  <p>For example :</p>
  
  <pre><code>Name              Statistics 
  
  Amsterdam         {"Births:" 23456}
  
  Chicago           {"Births:" 67890}
  </code></pre>
  
  <p>And I would want the output to be :</p>
  
  <pre><code>Name         Births 
  
  Amsterdam    23456
  
  Chicago      67890
  </code></pre>
  
  <p>I suppose I should use REGEXP ,but nothing seems to work in my case . </p>
  
  <p>Name and Births are both columns.</p>