Programming/SQL

[MySQL] lv.2 ์ค‘์„ฑํ™” ์—ฌ๋ถ€ ํŒŒ์•…ํ•˜๊ธฐ | CASE WHEN ์ด์šฉ

ํ•ด๋“œ์œ„๊ทธ 2024. 2. 11. 15:58
๋ฐ˜์‘ํ˜•

๋ฌธ์ œ:

 

 

์ฝ”๋“œ: 

-- ์ฝ”๋“œ๋ฅผ ์ž…๋ ฅํ•˜์„ธ์š”
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
ORDER BY ANIMAL_ID

 

ํ’€์ด:

CASE WHEN์„ ์‚ฌ์šฉํ•˜๋ฉด ๋œ๋‹ค.

CASE
	WHEN ์กฐ๊ฑด
	THEN '๋ฐ˜ํ™˜ ๊ฐ’'
	WHEN ์กฐ๊ฑด
	THEN '๋ฐ˜ํ™˜ ๊ฐ’'
	ELSE 'WHEN ์กฐ๊ฑด์— ํ•ด๋‹น ์•ˆ๋˜๋Š” ๊ฒฝ์šฐ ๋ฐ˜ํ™˜ ๊ฐ’'
END

 

SELECT ์ค‘๊ฐ„์—  ์‚ฌ์šฉ!

 

๋ฐ˜์‘ํ˜•