MySql中 case then when end用法

1.

case 字段名 when 字段名的具体值

select *,
case
	sex when '男' ehen '雄性' 
	else '雌性' 
	end as '性别'
from student 

2.

case when 字段名（这个可以对字段进行取范围）

select *,
case
	when age between'18' and '20' then'少男少女'
	when age between'10' and '17' then'少男女'
	else'大妈大叔' 
	end as'类别'
from student 

3.

case when 字段1,字段2(可以对多个字段进行替换,如果两个条件都针对一条数据的话，会显示第一个when的值)

select *,
case
	when age between '10' and '20' then '少男少女'
	when sex ='男' then '男人'
	else '不可知'
	end as '描述'
from student