mysql select case

第一种用法:
SELECT name,
CASE WHEN birthday < '1981' THEN 'old' 
WHEN birthday > '1988' THEN 'yong'
ELSE 'ok' END YORN
FROM lee




第二种用法：
SELECT NAME, CASE name
WHEN 'sam' THEN 'yong'
WHEN 'lee' THEN 'handsome'
ELSE 'good' END as oldname
FROM lee




第三种：当然了，case when 语句还可以复合
select name, birthday,
case 
when birthday > '1983' then 'yong'
when name='lee' then 'handsome'
else 'just so so' end
from lee;