case when then
格式:
case XX
when YY then WW
when YY then WW
when YY then WW
else//其他情况
MM
end
实例:
SELECT
CASE
WHEN id = 1 THEN
‘会员’
WHEN id = ‘2’ THEN
‘友客’
ELSE
‘其他’
END AS 等级
FROM
customdb.t_level_config_info
解析:当when的表达式为{真}时,就返回then后的值,否则就返回else后面的值