문제 답변 1 2 3 4 5 6 7 8 9 SELECT BOARD_ID , WRITER_ID , TITLE , PRICE, CASE WHEN STATUS = "SALE" THEN "판매중" WHEN STATUS = "RESERVED" THEN "예약중" WHEN STATUS = "DONE" THEN "거래완료" END AS STATUS FROM USED_GOODS_BOARD WHERE DATE_FORMAT(CREATED_DATE, "%Y-%m-%d") = "2022-10-05" ORDER BY BOARD_ID DESC Colored by Color Scripter cs 해당 문제의 경우 case when 문법을 통해 해결하였다.
