mysql正则表达式 判断字段值不包含数字
ifnull(SUM(`m`.`right_eyesight` REGEXP '[0-9]+' OR `m`.`left_eyesight` REGEXP '[0-9]+'),0) AS '视力检测人数'
NOT REGEXP '[0-9]+'
纵有白头俱老意,奈何缘浅路芊芊.
ifnull(SUM(`m`.`right_eyesight` REGEXP '[0-9]+' OR `m`.`left_eyesight` REGEXP '[0-9]+'),0) AS '视力检测人数'
NOT REGEXP '[0-9]+'