SELECT * FROM zipcode_street

WHERE STREET NOT LIKE '%길' AND STREET NOT LIKE '%로' AND STREET NOT LIKE '%거리' AND STREET NOT LIKE '%고개'