1.简单case 函数
SELECT
s.s_id,
s.s_name,
s.s_sex,
CASE s.s_sex
WHEN '1' THEN '男'
WHEN '2' THEN '女'
ELSE '其他'
END as sex,
s.s_age,
s.class_id
FROM
t_b_student s
WHERE
1 = 1
2.case 搜索函数
SELECT customer_id ,points ,
CASE WHEN points>3000
THEN 'gold customer'
ELSE 'sliver customer'
END AS status
FROM customers