Weather Observation Station 8

  • + 0 comments

    For performance (no regex) mysql;

    select city from station where (left(city, 1)) in ('a','e','i','o','u')
    		intersect
    select city from station where (right(city, 1)) in ('a','e','i','o','u')