[MySQL] lv.2 조건에 부합하는 중고거래 상태 조회하기 | CASE WHEN

코드:

-- 코드를 입력하세요
SELECT BOARD_ID, WRITER_ID, TITLE, PRICE,
CASE
WHEN STATUS = 'DONE'
THEN '거래완료'
WHEN STATUS = 'SALE'
THEN '판매중'
WHEN STATUS = 'RESERVED'
THEN '예약중'
END AS 'STATUS'
FROM USED_GOODS_BOARD
WHERE DATE_FORMAT(CREATED_DATE, '%Y-%m-%d') = '2022-10-05'
ORDER BY BOARD_ID DESC

 

풀이:

CASE WHEN 활용!

***