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);}