在mysql数据库中,往往有多判断的出现。例如在客户的银行卡表中t_bank_info(id,bank_no,bank_state.....,user_id),我们需要查询用户的银行卡状态
SELECT
b.`bank_no`,
b.`bank_state` ,
CASE WHEN b.`bank_state`=0 THEN '已绑定'
WHEN b.`bank_state`=1 THEN '变更中'
WHEN b.`bank_state`=2 THEN '变更失败'
END '卡状态'
FROM
t_bank_info b
WHERE b.'user_id'=100001'
所以此次用到的是 case when then end 判断语句