REGEXP
SELECT DISTINCT CITY
FROM STATION
WHERE CITY REGEXP '^[^aeiou]' AND
CITY REGEXP '[^aeiou]$'REGEXP_LIKE
SELECT DISTINCT CITY
FROM STATION
WHERE REGEXP_LIKE(CITY, '^[^AEIOU].*[^aeiou]$');NOT IN
SELECT DISTINCT CITY
FROM STATION WHERE (LEFT(CITY,1) NOT IN ('a','e','i','o','u') AND RIGHT(CITY,1) NOT IN ('a','e','i','o','u'));