CODE EXAMPLE FOR SQL

Pattern Sql Rlike same as REGEXP

select DISTINCT(CITY) from STATION where CITY RLIKE '^[^aeiou]' and CITY RLIKE '[^aeiou]$';