CASE문

SELECT ORDER_ID, PRODUCT_ID, 
	DATE_FORMAT(OUT_DATE, "%Y-%m-%d" ) AS OUT_DATE,
    CASE WHEN OUT_DATE <= '2022-05-01' THEN '출고완료'
        WHEN OUT_DATE > '2022-05-01'THEN '출고대기'
        ELSE '출고미정' 
    END '출고여부'
    FROM FOOD_ORDER
ORDER BY ORDER_ID

IF문

SELECT ORDER_ID , PRODUCT_ID ,
    DATE_FORMAT(OUT_DATE,'%Y-%m-%d') AS OUT_DATE, 
    IF(OUT_DATE <='2022-05-01',
    '출고완료',IF(OUT_DATE>'2022-05-01','출고대기',
    '출고미정')) AS 출고여부
FROM FOOD_ORDER
ORDER BY ORDER_ID