when case 를 이용한 문자열 대치

select case when bookcategoryid='ENG01' then '소설'
when bookcategoryid='ENG03' then '시/에세이'
when bookcategoryid='ENG05' then '인문'
when bookcategoryid='ENG21' then '종교'
when bookcategoryid='ENG19' then '역사/문화'
when bookcategoryid='ENG23' then '예술/대중문화'
when bookcategoryid='ENG13' then '경제/경영'
when bookcategoryid='ENG15' then '자기계발'
when bookcategoryid='ENG17' then '정치/사회'
when bookcategoryid='ENG41' then '유아'
when bookcategoryid='ENG42' then '아동'
when bookcategoryid='ENG39' then '초등학습'
when bookcategoryid='ENG25' then '중/고학습'
when bookcategoryid='ENG38' then '청소년'
when bookcategoryid='ENG31' then '취업/수험서'
when bookcategoryid='ENG27' then '외국어'
when bookcategoryid='ENG09' then '건강'
when bookcategoryid='ENG29' then '과학'
when bookcategoryid='ENG26' then '기술/공학'
when bookcategoryid='ENG33' then '컴퓨터/IT'
when bookcategoryid='ENG07' then '가정/생활'
when bookcategoryid='ENG08' then '요리'
when bookcategoryid='ENG11' then '취미/스포츠'
when bookcategoryid='ENG32' then '여행/기행'
when bookcategoryid='ENG47' then '만화'
else '기타' end as bookcategoryname
 , count(*) from bookbank group by bookcategoryid order by bookcategoryid asc;

몇개이든 상관 없습니다.
그냥 나열하듯 이렇게 조건을 걸어두면 된답니다.