PHP mysql更新没有整数

Question

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:

  $sql = "SELECT time FROM `arms`";
  $results = $conn->query($sql);
  $sql = "update `arms` set colB=preg_replace("/[0-9]/", "", 'colA')";
  $results = $conn->query($sql);

Also tried

  $sql = "update arms_ms set colB= " .preg_replace("/[0-9]/", "", colA). ""; 

Also tried

  $sql = "update arms_ms set colB= colA REGEXP /^([^0-9]*)$/;  

Have even tried

$sql = "update arms_ms set colB= common_schema.replace_all(colA,'0123456789','') ";

None of the above work.

Answer 1

MySQL does not support regex replace.

Although it's a bit tedious, you can do it this way:

update arms_ms set
colB = replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(colA,'0',''),'1',''),'2',''),'3',''),'4',''),'5',''),'6',''),'7',''),'8',''),'9','')