mysql case

case 컬럼명 when '원본값' then '바꿀값' else '기본값' end

ex.)
select case school when 'high' then '고등학교'
when 'univ' then '대학교'
else '중학교'
end as school from ~~~