SQL通配符筛选字母、汉字、数字
不包含字母
where column_name not like ‘%[A-Za-z]%’
或
where column_name like ‘%[^A-Za-z]%’
不包含汉字
where column_name not like ‘%[吖-座]%’
或
where column_name like ‘%[^吖-座]%’
不包含数字
where column_name not like ‘%[0-9]%’
或
where column_name like ‘%[^0-9]%’