SQL query to find a list of city names that dont start with vowels
<p>I'm trying to query the list of CITY names from table - STATION that do not start with vowels with results that cannot contain duplicates.
The table just has id, city, population</p>

<p>This is the query that I've written</p>

<pre><code>SELECT DISTINCT CITY FROM STATION 
WHERE CITY RLIKE '[^bcdfghjklmnpqrstvwxyzBCDFGHJKLMNPQRSTVWXYZ].*';
</code></pre>

<p>This gives a wrong answer. What am I doing wrong here?</p>