select * , case
when status=1 then '临时会员'
when status=2 then '注册会员'
when status=0 then '冻结帐户'
else ''
end
from tb_user
where
isnull(account,'')<>'' and (account like '%[吖-座]%' or
account like '%[a-z]%'
or account like '%-%' or account like '% %' ) order by status