You are viewing a single comment's thread. Return to all comments →
This can be simplied I believe but here is my =soultion for MySQL Luckily left doesnt get greedy in these type of situations.
select distinct city from station where right(city, 1) in ('a','e','i','o','u') and left(city, 1) in ('a','e','i','o','u');
Weather Observation Station 8
You are viewing a single comment's thread. Return to all comments →
This can be simplied I believe but here is my =soultion for MySQL Luckily left doesnt get greedy in these type of situations.