mysql找到包含非ASCII、非中文字符值的记录

— 查询非ASCII编码的数据

SELECT email_id,send_log FROM redm_email_others WHERE NOT HEX(send_log) REGEXP ‘^([0-7][0-9A-F])*$’;

?

— 查询ACSII编码数据

SELECT email_id,send_log ?FROM redm_email_others WHERE HEX(send_log) REGEXP ‘^([0-7][0-9A-F])*$’;

?

— 查询非中文编码数据

SELECT email_id,send_log FROM redm_email_others WHERE NOT HEX(send_log) REGEXP ‘e[4-9][0-9A-F]{4}’;

?