case when then else end用法 1、基本用法 CASE expr WHEN v1 THEN r1 [WHEN v2 THEN r2]…[ELSE rn+1] END:如果expr值等于某个vn,则返回对应位置THEN后面的结果;如果与所有值都不相等,则返回ELSE后面的rn+1 case 后面不跟值 SELECT age, CASE WHEN age >20 THEN 'old' WHEN age <=20 THEN 'young' ELSE '未知' END AS `status` FROM test; ============================