0510 TIL

SQL 문제풀기

경기도에 위치한 식품창고 목록 출력하기

SELECT WAREHOUSE_ID, WAREHOUSE_NAME, ADDRESS, IFNULL(FREEZER_YN,'N') as FREEZER_YN
FROM FOOD_WAREHOUSE
WHERE WAREHOUSE_NAME LIKE '%_경기%'
ORDER BY WAREHOUSE_ID ASC

문제를 잘 읽자..
문제부터 경기도에 위치한인데 그걸 빼먹으면 되냐고..

SELECT WAREHOUSE_ID, WAREHOUSE_NAME, ADDRESS, IF(FREEZER_YN IS NULL,'N',FREEZER_YN) AS FREEZER_YN
FROM FOOD_WAREHOUSE
WHERE WAREHOUSE_NAME LIKE '%_경기%'
ORDER BY WAREHOUSE_ID ASC

IF문 안에 FREEZER_YN=NULL 하면 못 알아들음
IS NULL를 써줘야함