[SQL] 중성화 여부 파악하기 - CASE문 (LIKE) 예시

SELECT
    CASE 
    	WHEN [컬럼명] LIKE 'AAA%' THEN [조건값1]
        WHEN [컬럼명] LIKE 'BBB%' THEN [조건값2]
        ELSE [조건값3]
    END AS [새로운컬럼명]
FROM [테이블명]

SELECT 
    ANIMAL_ID,
    NAME, 
    CASE WHEN SEX_UPON_INTAKE LIKE 'Neutered%' THEN 'O'
        WHEN SEX_UPON_INTAKE LIKE 'Spayed%' THEN 'O'
        ELSE 'X' 
    END AS '중성화'
FROM ANIMAL_INS
ORDER BY ANIMAL_ID;