mysql case when 用法

1、mysql case when用法

 

2、mysql中case when的用法

1.等值转换

select name as '姓名',
(case sex when 0 then '女' else '男' end) as '性别'
from test.student;

2.范围转换

select name as '姓名',
(case when score > 90 then '优' when score >= 80 then '良' when score >= 60 then '及格' else '不及格' end) as '等级'
from test.stu_score;