select * from table where cname like '%[吖-座]%'
select * from table where ename like '%[a-z]%'
select * from table where enmae like '%[0-9]%'
select * from table where cname like '%[吖-座]%'
select * from table where ename like '%[a-z]%'
select * from table where enmae like '%[0-9]%'