[String, Date/LEVEL2] 조건에 부합하는 중고거래 상태 조회하기 (MySQL/Oracle)

MySQL

SELECT 
  BOARD_ID
, WRITER_ID
, TITLE
, PRICE
, CASE WHEN STATUS = 'SALE' THEN '판매중' 
       WHEN STATUS = 'RESERVED' THEN '예약중'
       WHEN STATUS = 'DONE' THEN '거래완료'
       END STATUS
FROM USED_GOODS_BOARD
WHERE CREATED_DATE = '2022-10-05'
ORDER BY BOARD_ID DESC

 

---

Oracle

SELECT 
  BOARD_ID
, WRITER_ID
, TITLE
, PRICE
, CASE WHEN STATUS = 'SALE' THEN '판매중' 
       WHEN STATUS = 'RESERVED' THEN '예약중'
       WHEN STATUS = 'DONE' THEN '거래완료'
       END STATUS
FROM USED_GOODS_BOARD
WHERE CREATED_DATE = TO_DATE('2022-10-05', 'YYYY-MM-DD')
ORDER BY BOARD_ID DESC
;

• 평소였다면 WHERE TO_CHAR(CREATED_DATE, 'YYYY-MM-DD') = '2022-10-05' 로 사용했겠지만 성능개선까지 고려하여 짜봄ㅋㅋㅋㅋㅋ