mysql正则表达式判断字段值不包含数字

ifnull(SUM(`m`.`right_eyesight` REGEXP '[0-9]+' OR `m`.`left_eyesight` REGEXP '[0-9]+'),0) AS '视力检测人数'

NOT REGEXP '[0-9]+'

posted @ 2022-02-23 10:14 hanby 阅读(244) 评论(0) 收藏举报