mysql如何判断数字是科学计数法

mysql如何判断数字是科学计数法

//判断科学计数法
public function checkCellFormat($md5_value){
      $sql = "SELECT count(*) as count FROM order WHERE md5_value='".$md5_value."' and (原始单号 RLIKE '^[+-]?[0-9]+(\.[0-9]+)?[eE][+-]?[0-9]+$' or 商家编码 RLIKE '^[+-]?[0-9]+(\.[0-9]+)?[eE][+-]?[0-9]+$' or 货品编号 RLIKE '^[+-]?[0-9]+(\.[0-9]+)?[eE][+-]?[0-9]+$' or 物流单号 RLIKE '^[+-]?[0-9]+(\.[0-9]+)?[eE][+-]?[0-9]+$' or 订单编号 RLIKE '^[+-]?[0-9]+(\.[0-9]+)?[eE][+-]?[0-9]+$' or 原始子单号 RLIKE '^[+-]?[0-9]+(\.[0-9]+)?[eE][+-]?[0-9]+$')";
      \PhalApi\DI()->logger->error('log', ['msg'=>$sql]);
      return $this->getORM()->queryAll($sql);
}

发表评论

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen: