title: How do you extract a numerical value from a string in a MySQL query?
body: <p>I have a table with two columns: price (int) and price_display (varchar).</p>
  
  <p>price is the actual numerical price, e.g. "9990"</p>
  
  <p>price_display is the visual representation, e.g. "$9.99" or "9.99Fr"</p>
  
  <p>I've been able to confirm the two columns match via regexp:</p>
  
  <blockquote>
    <p>price_display not regexp
    format(price/1000, 2)</p>
  </blockquote>
  
  <p>But in the case of a mismatch, I want to extract the value from the price_display column and set it into the price column, all within the context of an update statement.  I've not been able to figure out how.</p>
  
  <p>Thanks.</p>