[MySQL] 중성화 여부 파악하기

 

정답

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