① case 字段 when 值
SELECT
NAME,
CASE NAME
WHEN '小野星' THEN '瑟瑟发抖的萌新'
ELSE '老司机'
END AS '职业'
FROM
DRIVER;
② case when 字段,这个可以范围取值
使用时需要注意,多个when指向单个字段时, 满足一个条件,
只会显示一个结果when的值
SELECT
NAME,
CASE
WHEN NO BETWEEN 0 AND 20 THEN '青年'
WHEN NO BETWEEN 20 AND 40 THEN '中年'
ELSE '非人类'
END AS '描述'
FROM
DRIVER;
③ case when 字段 1,字段2,可以对多个字段进行替换
SELECT
ID,NAME,
CASE
WHEN ID BETWEEN 12 AND 16 THEN '青年'
WHEN NAME = '小野星' THEN '帅气'
END AS '描述'
FROM
DRIVER;
欢迎各位大佬补充