You are viewing a single comment's thread. Return to all comments →
This is in Oracle SQL without REGEX using only basic SELECT statements. It's easy to read. Hope it helps.
SELECT city FROM station WHERE ( LOWER(city) LIKE 'a%' OR LOWER(city) LIKE 'e%' OR LOWER(city) LIKE 'i%' OR LOWER(city) LIKE 'o%' OR LOWER(city) LIKE 'u%' ) AND ( LOWER(city) LIKE '%a' OR LOWER(city) like '%e' OR LOWER(city) LIKE '%i' OR LOWER(city) LIKE '%o' OR LOWER(city) LIKE '%u' );
Seems like cookies are disabled on this browser, please enable them to open this website
Weather Observation Station 8
You are viewing a single comment's thread. Return to all comments →
This is in Oracle SQL without REGEX using only basic SELECT statements. It's easy to read. Hope it helps.