CASE case_value
WHEN when_value THEN
statement_list
ELSE
statement_list
ENDCASE;
一个case 的使用:
SELECTCASE category
when'student'then0when'company'then1ELSE'344'ENDas'level'from(SELECT ur.category
from user_role urr
LEFTJOIN role ur
on urr.role_id = ur.id
)as tt;
多个case 的使用:
SELECT*,(CASE uc.flag
when uc.flag=1then'充值'when uc.flag=2then'提現'when uc.flag=3then'投资'END),(CASEwhen uc.status=1then'正在申请'when uc.status=2then'待确认'when uc.status=3then'已确认'END),(CASE uc.account
WHEN1THEN'数字货币'when1then'美元'END),
uc.balance as'余额'from user_cash uc
LEFTJOINuser u
on uc.user_id = u.id;
记录一次Mysql 的Case 的使用case 命令的模式:CASE case_value WHEN when_value THEN statement_list ELSE statement_listEND CASE;一个case 的使用:SELECT CASE category when 'student' then 0 when 'company' then 1 ELSE '344' END as 'level'f