sql语句中case的使用

 

select case grade when 1 then '金牌会员' when 2 then '银牌会员' when 3 then '普通会员' end jb
from t_member_user
where sq=1 and isshow=0 order by t_member_user.Id desc