ㅋㅌ

[SQL] WHERE ** LIKE '**%'

quarrrter 2023. 8. 22. 14:28
SELECT WAREHOUSE_ID, WAREHOUSE_NAME, ADDRESS, coalesce(FREEZER_YN, 'N') AS FREEZER_YN
FROM FOOD_WAREHOUSE
WHERE ADDRESS LIKE '경기도%'
ORDER BY WAREHOUSE_ID ASC;

경기도로 시작하는 ~