SELECT에서 조건문 사용하기

방법 - 1

select
	CASE {TARGET_COLUMN_NAME}
		WHEN {TARGET_VALUE} THEN {VALUE}
		WHEN {TARGET_VALUE} THEN {VALUE}
		ELSE {VALUE}
	END as {COLUMN_NAME}
from {TABLE_NAME}

방법 - 2

select
	CASE
		WHEN {COMPARE} THEN {VALUE}
		WHEN {COMPARE} THEN {VALUE}
		ELSE {VALUE}
	END as {COLUMN_NAME}
from {TABLE_NAME}

참고

• http://irontooth.tistory.com/88
  
• http://www.sqler.com/?mid=bSQLQA&listStyle=webzine&page=8&document_srl=435366