MySQL字段数据全部查出【只保留中文、英文、数字、空格的词表】

select
    *
from
    xxx_xxx_bak
where slot_type_id in ('xxx', 'xxx')
and not (HEX(xxx_xxx) regexp '[[:<:]](e[4-9][0-9a-f]{4}|3[0-9]|4[0-9A-F]|5[0-9A]|6[0-9A-F]|7[0-9A]|20)+[[:>:]]') and length(slot_value) != char_length(slot_value) and char_length(slot_value) != 1
;

by @大超超

记录备查