title: PHP mysql update without integers
body: <p>Need a PHP MYSQL query that will copy data from one column into another while stripping it of numbers before placing into the new column. Tried the following:</p>
  
  <pre><code>  $sql = "SELECT time FROM `arms`";
    $results = $conn-&gt;query($sql);
    $sql = "update `arms` set colB=preg_replace("/[0-9]/", "", 'colA')";
    $results = $conn-&gt;query($sql);
  </code></pre>
  
  <p>Also tried </p>
  
  <pre><code>  $sql = "update arms_ms set colB= " .preg_replace("/[0-9]/", "", colA). ""; 
  </code></pre>
  
  <p>Also tried </p>
  
  <pre><code>  $sql = "update arms_ms set colB= colA REGEXP /^([^0-9]*)$/;  
  </code></pre>
  
  <p>Have even tried</p>
  
  <pre><code>$sql = "update arms_ms set colB= common_schema.replace_all(colA,'0123456789','') ";
  </code></pre>
  
  <p>None of the above work.</p>