mysql CASE WHEN

一、语法

case
	when [表达式] then [值]
	when [表达式] then [值]
	else 值
	end;

二、示列

SELECT * ,
    CASE 
        WHEN score<60 THEN '差'
        WHEN score>=60 AND score<80 THEN '中'
        WHEN score>=80 AND score<90 THEN '良'
        WHEN score>=90  THEN '优' END level
FROM pwx;