blocks|key|994404|text|假设您使用的是MySQL，下面是您要寻找的|type|unstyled|depth|inlineStyleRanges|entityRanges|data|994405|SELECT+DISTINCT+city+FROM+station+WHERE+city+RLIKE+'%5E[%5EaeiouAEIOU].*%7C.*[%5EAEIOUaeiou]$';|code-block|syntax|javascript|994406|脚注：里科和分异|offset|length|994407|entityMap|0|LINK|mutability|MUTABLE|url|http://www.sqlines.com/mysql/regexp_rlike|1|http://www.dofactory.com/sql/select-distinct^0|0|0|3|2|0|6|2|1|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@]|9|@$I|X|J|Y|1|Z]|$I|10|J|11|1|12]]|A|$]]|$1|K|3|-4|5|6|7|13|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]|S|$5|N|O|P|A|$Q|T]]]]

Assuming you are using MySQL, Here is what you are looking for
<pre class="lang-sql prettyprint-override"><code>SELECT DISTINCT city FROM station WHERE city RLIKE '^[^aeiouAEIOU].*|.*[^AEIOUaeiou]$';
</code></pre>
Footnote : <a href="http://www.sqlines.com/mysql/regexp_rlike" rel="nofollow noreferrer">RLIKE</a> and <a href="http://www.dofactory.com/sql/select-distinct" rel="nofollow noreferrer">DISTINCT</a>

blocks|key|995010|text|此SQL查询将对您有所帮助。如果您使用的是MS，那么请遵循下面给出的代码行：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|995011|SELECT+DISTINCT+CITY+
FROM+STATION++
WHERE+CITY+NOT+LIKE+'[AEIOU]%25'+OR+CITY+NOT+LIKE+'%25[aeiou]';|code-block|syntax|javascript|995012|如果您使用的是MySQL，那么请遵循下面给出的代码行：|995013|SELECT+DISTINCT+CITY+
FROM+STATION+
WHERE+(CITY+NOT+IN+(SELECT+DISTINCT+CITY+FROM+STATION+WHERE+CITY+LIKE+'%25a'+OR+CITY+LIKE+'%25e'+OR+CITY+LIKE+'%25i'+OR+CITY+LIKE+'%25o'+OR+CITY+LIKE+'%25u'))
OR+
(CITY+NOT+IN+(SELECT+CITY+FROM+STATION+WHERE+CITY+LIKE+'A%25'+OR+CITY+LIKE+'E%25'+OR+CITY+LIKE+'I%25'+OR+CITY+LIKE+'O%25'+OR+CITY+LIKE+'U%25'));|995014|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

This SQL Query will helpful for you. 
If you are using MS SQL then follow this line of code given below:

<pre><code>SELECT DISTINCT CITY 
FROM STATION 
WHERE CITY NOT LIKE '[AEIOU]%' OR CITY NOT LIKE '%[aeiou]';
</code></pre>

If you are using MySQL then follow this line of code given below:

<pre><code>SELECT DISTINCT CITY 
FROM STATION 
WHERE (CITY NOT IN (SELECT DISTINCT CITY FROM STATION WHERE CITY LIKE '%a' OR CITY LIKE '%e' OR CITY LIKE '%i' OR CITY LIKE '%o' OR CITY LIKE '%u'))
OR 
(CITY NOT IN (SELECT CITY FROM STATION WHERE CITY LIKE 'A%' OR CITY LIKE 'E%' OR CITY LIKE 'I%' OR CITY LIKE 'O%' OR CITY LIKE 'U%'));
</code></pre>

blocks|key|994730|text|SELECT+DISTINCT+city
FROM+++station
WHERE++city+REGEXP+'%5E[%5EaeiouAEIOU]%7C[%5EaeiouAEIOU]$'|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|994731|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>SELECT DISTINCT city
FROM station
WHERE city REGEXP '^[^aeiouAEIOU]|[^aeiouAEIOU]$'
</code></pre>

blocks|key|716857|text|+SELECT+DISTINCT+city+FROM+station+WHERE+city+RLIKE+'%5E[%5EaeiouAEIOU].*+
+[%5EaeiouAEIOU]$';|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|716858|您必须将插入字符放在方括号内，这意味着没有任何元音。这里是解释|unstyled|offset|length|716859|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/16944517/4177764^0|0|Q|2|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|R|8|@]|9|@$G|S|H|T|1|U]]|A|$]]|$1|I|3|-4|5|F|7|V|8|@]|9|@]|A|$]]]|J|$K|$5|L|M|N|A|$O|P]]]]

<pre><code> SELECT DISTINCT city FROM station WHERE city RLIKE '^[^aeiouAEIOU].* 
 [^aeiouAEIOU]$';
</code></pre>

You have to place caret character inside square brackets which means not any vowels. <a href="https://stackoverflow.com/a/16944517/4177764">Here</a> is explanation

blocks|key|1983540|text|尝试以下几点：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1983541|SELECT+city+
FROM+station+
WHERE+left(city,1)+not+regexp+'a%7Ce%7Ci%7Co%7Cu'+or+right(city,1)+not+regexp+'a%7Ce%7Ci%7Co%7Cu'+
GROUP+BY+city|code-block|syntax|javascript|1983542|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Try the following:

<pre><code>SELECT city 
FROM station 
WHERE left(city,1) not regexp 'a|e|i|o|u' or right(city,1) not regexp 'a|e|i|o|u' 
GROUP BY city
</code></pre>

blocks|key|716812|text|如果您正在使用Oracle，此SQL查询将对您有所帮助。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|716813|SELECT+DISTINCT+city
FROM+station
WHERE+regexp_like+(city,+'%5E[%5EaeiouAEIOU].*')+
OR+regexp_like+(city,+'.*[%5EaeiouAEIOU]$');|code-block|syntax|javascript|716814|如果您使用Oracle，另一个答案是：|716815|SELECT+DISTINCT+(CITY)+
FROM+STATION+
WHERE+NOT+regexp_like(lower(CITY),'%5E[aeiou].*[aeiou]$');|716816|entityMap^0|7|6|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|U|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|V|8|@]|D|@]|E|$I|J]]|$1|O|3|-4|5|6|7|W|8|@]|D|@]|E|$]]]|P|$]]

This SQL Query will helpful for you if you are using <code>Oracle</code>:

<pre><code>SELECT DISTINCT city
FROM station
WHERE regexp_like (city, '^[^aeiouAEIOU].*') 
OR regexp_like (city, '.*[^aeiouAEIOU]$');
</code></pre>

Another answer if you are using Oracle:

<pre><code>SELECT DISTINCT (CITY) 
FROM STATION 
WHERE NOT regexp_like(lower(CITY),'^[aeiou].*[aeiou]$');
</code></pre>

blocks|key|717155|text|您可以在MySQL上尝试这样的方法：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|717156|SELECT+DISTINCT(CITY)+
FROM+STATION+
WHERE+CITY+NOT+REGEXP+'%5E[aeiou]'+
++++AND+CITY+NOT+REGEXP+'[aeiou]$';|code-block|syntax|javascript|717157|此查询将为所询问的问题提供所需的输出。|717158|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

You could try this for MySQL:
<pre><code>SELECT DISTINCT(CITY) 
FROM STATION 
WHERE CITY NOT REGEXP '^[aeiou]' 
 AND CITY NOT REGEXP '[aeiou]$';
</code></pre>
This query will bring you the desired output for the asked question.

blocks|key|716923|text|试试这个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|716924|select+DISTINCT+city+from+STATION+
where++(CITY+NOT+LIKE+'a%25'
++++++++AND+CITY++NOT+LIKE+'e%25'
++++++++AND+CITY+NOT+LIKE+'i%25'+
++++++++AND+CITY+NOT+LIKE+'o%25'
++++++++AND+CITY+NOT+LIKE+'u%25')
OR+(CITY+NOT+LIKE+'%25a'+AND
++++CITY++NOT+LIKE+'%25e'+AND
++++CITY+NOT+LIKE+'%25i'+AND+
++++CITY+NOT+LIKE+'%25o'+AND+
++++CITY+NOT+LIKE+'%25u')|code-block|syntax|javascript|716925|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Try this:

<pre><code>select DISTINCT city from STATION 
where (CITY NOT LIKE 'a%'
 AND CITY NOT LIKE 'e%'
 AND CITY NOT LIKE 'i%' 
 AND CITY NOT LIKE 'o%'
 AND CITY NOT LIKE 'u%')
OR (CITY NOT LIKE '%a' AND
 CITY NOT LIKE '%e' AND
 CITY NOT LIKE '%i' AND 
 CITY NOT LIKE '%o' AND 
 CITY NOT LIKE '%u')
</code></pre>

blocks|key|994514|text|Oracle解决方案：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|994515|SELECT+DISTINCT+CITY+FROM+STATION+WHERE+
NOT+REGEXP_LIKE(UPPER(CITY),+'%5E[AEIOU]')+OR+
NOT+REGEXP_LIKE(UPPER(CITY),+'[AEIOU]$');+|code-block|syntax|javascript|994516|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Oracle solution:

<pre class="lang-sql prettyprint-override"><code>SELECT DISTINCT CITY FROM STATION WHERE 
NOT REGEXP_LIKE(UPPER(CITY), '^[AEIOU]') OR 
NOT REGEXP_LIKE(UPPER(CITY), '[AEIOU]$'); 
</code></pre>

blocks|key|994645|text|SELECT+DISTINCT+CITY+FROM+STATION+WHERE+CITY+REGEXP+'%5E[%5Eaeiou]%7C[%5Eaeiou]$';|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|994646|这就是你要找的兄弟。|unstyled|994647|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP '^[^aeiou]|[^aeiou]$';
</code></pre>

this is what you are looking for bro.

blocks|key|1984041|text|这是MS+SQL+SERVER所需的解决方案，|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1984042|select+distinct+city+from+station+where+city+not+like+'[aeiouAEIOU]%25'+and+city+not+like+'%25[aeiouAEIOU]'|code-block|syntax|javascript|1984043|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This is a required solution for MS SQL SERVER,
<pre class="lang-sql prettyprint-override"><code>select distinct city from station where city not like '[aeiouAEIOU]%' and city not like '%[aeiouAEIOU]'
</code></pre>

blocks|key|717621|text|SELECT+DISTINCT+CITY+
FROM+STATION+
WHERE+
++SUBSTRING(CITY,1,1)+NOT+IN+('A','E','I','O','U')+
++OR+
++SUBSTRING(CITY,1,1)+NOT+IN+('a','e','i','o','u')|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|717622|此代码适用于MS+SQL+SERVER。|unstyled|717623|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>SELECT DISTINCT CITY 
FROM STATION 
WHERE 
 SUBSTRING(CITY,1,1) NOT IN ('A','E','I','O','U') 
 OR 
 SUBSTRING(CITY,1,1) NOT IN ('a','e','i','o','u')
</code></pre>
This code works for MS SQL SERVER.

blocks|key|717639|text|代表MySQL+Select+DISTINCT+CITY+from+STATION+where+CITY+REGEXP+'%5E[%5Eaeiou]%7C[%5Eaeiou]$';|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|717640|entityMap^0|8|22|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

For MySQL
<code>Select DISTINCT CITY from STATION where CITY REGEXP '^[^aeiou]|[^aeiou]$';</code>

blocks|key|1983658|text|我做过这个|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1983659|SELECT+DISTINCT+CITY+FROM+STATION
WHERE+CITY+NOT+LIKE+'a%25'+
AND+CITY+NOT+LIKE+'e%25'
AND+CITY+NOT+LIKE+'i%25'
AND+CITY+NOT+LIKE+'o%25'
AND+CITY+NOT+LIKE+'u%25'
AND+CITY+NOT+LIKE+'%25a'+
AND+CITY+NOT+LIKE+'%25e'
AND+CITY+NOT+LIKE+'%25i'
AND+CITY+NOT+LIKE+'%25o'
AND+CITY+NOT+LIKE+'%25u'|code-block|syntax|javascript|1983660|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I worked with this

<pre><code>SELECT DISTINCT CITY FROM STATION
WHERE CITY NOT LIKE 'a%' 
AND CITY NOT LIKE 'e%'
AND CITY NOT LIKE 'i%'
AND CITY NOT LIKE 'o%'
AND CITY NOT LIKE 'u%'
AND CITY NOT LIKE '%a' 
AND CITY NOT LIKE '%e'
AND CITY NOT LIKE '%i'
AND CITY NOT LIKE '%o'
AND CITY NOT LIKE '%u'
</code></pre>

blocks|key|994454|text|select+distinct+CITY
from+STATION
where+SUBSTRING(CITY,+Length(CITY),+1)+NOT+in+('a','e','i','o','u','A','E','I','O','U')+
order+by+CITY|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|994455|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>select distinct CITY
from STATION
where SUBSTRING(CITY, Length(CITY), 1) NOT in ('a','e','i','o','u','A','E','I','O','U') 
order by CITY
</code></pre>

blocks|key|716886|text|Select+Distinct
+++++++City
From
+++++++Station
Where
+++++++Lower(Left(City,1))+not+in+('a','e','i','o','u')
+++++++or+Lower(Right(City,1))+not+in+('a','e','i','o','u')|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|716887|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>Select Distinct
 City
From
 Station
Where
 Lower(Left(City,1)) not in ('a','e','i','o','u')
 or Lower(Right(City,1)) not in ('a','e','i','o','u')
</code></pre>

blocks|key|994470|text|SELECT+DISTINCT+CITY+
FROM+STATION+
WHERE+
left(city,1)+NOT+IN+('a','e','i','o','u')+OR+RIGHT(city,1)+

NOT+IN+('a','e','i','o','u')|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|994471|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>SELECT DISTINCT CITY 
FROM STATION 
WHERE 
left(city,1) NOT IN ('a','e','i','o','u') OR RIGHT(city,1) 

NOT IN ('a','e','i','o','u')
</code></pre>

blocks|key|716968|text|这个对我有用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|716969|SELECT+DISTINCT+CITY+FROM+STATION+WHERE+NOT+CITY+RLIKE+'%5E[AEIOUaeiou]'+AND+NOT+CITY+RLIKE+'.*[AEIOUaeiou]$'+|code-block|syntax|javascript|716970|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This works for me

<pre><code>SELECT DISTINCT CITY FROM STATION WHERE NOT CITY RLIKE '^[AEIOUaeiou]' AND NOT CITY RLIKE '.*[AEIOUaeiou]$' 
</code></pre>

blocks|key|994491|text|mySQL+query:
SELECT+DISTINCT+CITY+FROM+STATION+WHERE+CITY+REGEXP+'%5E[%5Eaeiou]'+OR+CITY+REGEXP+'[%5Eaeiou]$'+|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|994492|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>mySQL query:
SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP '^[^aeiou]' OR CITY REGEXP '[^aeiou]$' 
</code></pre>

blocks|key|717024|text|对，回答这个，|type|unstyled|depth|inlineStyleRanges|entityRanges|data|717025|SELECT+DISTINCT+CITY+FROM+STATION
WHERE+NOT+CITY+RLIKE+'%5E[AEIOUaeiou]'+AND+NOT+CITY+RLIKE+'.*[AEIOUaeiou]$';|code-block|syntax|javascript|717026|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Right answer this , 

<pre><code>SELECT DISTINCT CITY FROM STATION
WHERE NOT CITY RLIKE '^[AEIOUaeiou]' AND NOT CITY RLIKE '.*[AEIOUaeiou]$';
</code></pre>

blocks|key|717030|text|select+distinct+city+
from+station
where+city+not+RLIKE+'%5E[aeiou]'+and+city+not+RLike+'[aeiou]$'|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|717031|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>select distinct city 
from station
where city not RLIKE '^[aeiou]' and city not RLike '[aeiou]$'
</code></pre>

blocks|key|1984138|text|您的问题的解决方案应该是以下查询：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1984139|select+DISTINCT+CITY+from+STATION+where+CITY+NOT+LIKE+'[a,e,i,o,u]%25'+OR
CITY+NOT+LIKE+'%25[a,e,i,o,u]'|code-block|syntax|javascript|1984140|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

A solution to your question should be the following query:

<pre><code>select DISTINCT CITY from STATION where CITY NOT LIKE '[a,e,i,o,u]%' OR
CITY NOT LIKE '%[a,e,i,o,u]'
</code></pre>

blocks|key|717578|text|MYSQL：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|717579|Select+distinct+city+from+station+where+city+not+regexp+'%5E[aeiou].*[aeiou]$'|code-block|syntax|javascript|717580|说明:使用正则表达式而不是条件。从根本上说，它是对城市的搜索，其开头是元音“%5Eaeiou”，中间由“n”值连接。以元音“aeiou$”结尾的运算符和第二个条件。最后，由于不适用条件，所以只有那些不符合标准的才会被过滤出来并显示出来。|717581|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

MYSQL:

<pre><code>Select distinct city from station where city not regexp '^[aeiou].*[aeiou]$'
</code></pre>

EXPLANATION :
 Using regular expression and NOT condition.
 So basically it is searches for the city which start with vowels '^[aeiou]' concatenated by 'n' values in between by '.' operator and second condition of ending with vowels '[aeiou]$'.
And at the end since NOT condition is applied ,so only the ones whic do not meet the criteria are filtered out and displayed.

blocks|key|717819|text|我使用它，它可以工作，它的ORACLE+SQL：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|717820|select+distinct+city+from+station+where+regexp_like(city,+'%5E[%5Eaeiou].*%7C.*[%5Eaeiou]$',+'i');|code-block|syntax|javascript|717821|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I use this and it works, its ORACLE SQL:
<pre><code>select distinct city from station where regexp_like(city, '^[^aeiou].*|.*[^aeiou]$', 'i');
</code></pre>

blocks|key|716861|text|使用MS+SQL+SERVER更正上述语句如下所示：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|716862|SELECT+DISTINCT+CITY+FROM+STATION+WHERE+CITY+NOT+LIKE+'[AEIOU]%25'+OR+CITY+NOT+LIKE+'[aeiou]**%25**';|code-block|syntax|javascript|716863|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Correction to the above statement using MS SQL SERVER is shown below:
<pre><code>SELECT DISTINCT CITY FROM STATION WHERE CITY NOT LIKE '[AEIOU]%' OR CITY NOT LIKE '[aeiou]**%**';
</code></pre>

blocks|key|994531|text|mysql查询：SELECT+DISTINCT+city+FROM+station+WHERE+city+NOT+REGEXP+'%5E[aeiouAEIOU].*[aeiouAEIOU]$';|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|994532|entityMap^0|8|2F|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

mysql query:
<code>SELECT DISTINCT city FROM station WHERE city NOT REGEXP '^[aeiouAEIOU].*[aeiouAEIOU]$';</code>

blocks|key|1983845|text|select+distinct+city
from+station+
where+not+lower(substr(city,1,1))+in+('a','e','i','o','u')
++++++or+not+lower(substr(city,-1,1))+in+('a','e','i','o','u');|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1983846|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>select distinct city
from station 
where not lower(substr(city,1,1)) in ('a','e','i','o','u')
 or not lower(substr(city,-1,1)) in ('a','e','i','o','u');
</code></pre>

blocks|key|994553|text|下面的查询应该做您想做的事情。对我来说很成功！|type|unstyled|depth|inlineStyleRanges|entityRanges|data|994554|SELECT+DISTINCT+CITY+
FROM+STATION
WHERE+CITY+NOT+RLIKE+'%5E[aeiouAEIOU]'+OR+CITY+NOT+RLIKE+'[aeiouAEIOU]$'|code-block|syntax|javascript|994555|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

The following query should do what you want. It worked for me successfully!

<pre><code>SELECT DISTINCT CITY 
FROM STATION
WHERE CITY NOT RLIKE '^[aeiouAEIOU]' OR CITY NOT RLIKE '[aeiouAEIOU]$'
</code></pre>

blocks|key|1983885|text|这对我使用MYSQL起了作用。我还将结果按城市分组，这并不是更漂亮的needed...just：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1983886|select+distinct+CITY
from+STATION
where+CITY+NOT+RLIKE+'%5E[aeiouAEIOU]'
++OR+CITY+NOT+RLIKE+'[AEIOUaeiou]$'
GROUP+BY+CITY;|code-block|syntax|javascript|1983887|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This worked for me using MYSQL. I also grouped the results by city, which is not needed...just prettier:

<pre><code>select distinct CITY
from STATION
where CITY NOT RLIKE '^[aeiouAEIOU]'
 OR CITY NOT RLIKE '[AEIOUaeiou]$'
GROUP BY CITY;
</code></pre>

blocks|key|717160|text|这将以您想要的方式工作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|717161|SELECT+city+
FROM+station+
WHERE+left(city,1)+not+regexp+'a%7Ce%7Ci%7Co%7Cu'+or+right(city,1)+not+regexp+'a%7Ce%7Ci%7Co%7Cu'+
GROUP+BY+city|code-block|syntax|javascript|717162|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This will work the way you want:

<pre><code>SELECT city 
FROM station 
WHERE left(city,1) not regexp 'a|e|i|o|u' or right(city,1) not regexp 'a|e|i|o|u' 
GROUP BY city
</code></pre>

blocks|key|717202|text|SELECT+distinct+city+FROM+station+
WHERE+City+not+LIKE+'[aeiou]%25'+and+CITY+NOT+LIKE+'%25[aeiou]'|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|717203|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>SELECT distinct city FROM station 
WHERE City not LIKE '[aeiou]%' and CITY NOT LIKE '%[aeiou]'
</code></pre>

blocks|key|1984026|text|假设您看到了这个关于黑客级别的问题，并给出了表站模式的截图，那么这个问题也说明了同样的问题。这是我的答案，它在MYSQL中对我有效。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1984027|select+DISTINCT(city)+from+STATION+where+CITY+REGEXP+'%5E[%5Eaeiou]'+or+CITY+REGEXP+'.*[%5Eaeiou]$';|code-block|syntax|javascript|1984028|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Assuming that you saw this question on hacker rank and given your screenshot of the table STATION schema also tells the same thing. Here is my answer and it worked for me in MYSQL.

<pre><code>select DISTINCT(city) from STATION where CITY REGEXP '^[^aeiou]' or CITY REGEXP '.*[^aeiou]$';

</code></pre>

blocks|key|717314|text|这个怎么样？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|717315|SELECT+CITY+from+STATION+WHERE+LOWER(CITY)+NOT+REGEXP+'%5E[aeiou].*[aeiou]$'+GROUP+BY+CITY|code-block|syntax|javascript|717316|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

How about this one:

<pre><code>SELECT CITY from STATION WHERE LOWER(CITY) NOT REGEXP '^[aeiou].*[aeiou]$' GROUP BY CITY
</code></pre>

blocks|key|1984060|text|MySQL+RLIKE操作符执行字符串表达式与模式的模式匹配。模式是作为参数提供的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1984061|SELECT+DISTINCT+city+FROM+station+
WHERE+city+NOT+RLIKE+'%5E[aeiouAEIOU].*[aeiouAEIOU]$';|code-block|syntax|javascript|1984062|参考文献：https://www.w3resource.com/mysql/string-functions/mysql-rlike-function.php+雷杰普|offset|length|1984063|entityMap|0|LINK|mutability|MUTABLE|url|https://www.w3resource.com/mysql/string-functions/mysql-rlike-function.php|1|https://dev.mysql.com/doc/refman/8.0/en/regexp.html#operator_regexp^0|0|0|5|22|0|28|3|1|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@]|9|@$I|X|J|Y|1|Z]|$I|10|J|11|1|12]]|A|$]]|$1|K|3|-4|5|6|7|13|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]|S|$5|N|O|P|A|$Q|T]]]]

MySQL RLIKE operator performs a pattern match of a string expression against a pattern. The pattern is supplied as an argument.

<pre><code>SELECT DISTINCT city FROM station 
WHERE city NOT RLIKE '^[aeiouAEIOU].*[aeiouAEIOU]$';
</code></pre>

Ref:
<a href="https://www.w3resource.com/mysql/string-functions/mysql-rlike-function.php" rel="nofollow noreferrer">https://www.w3resource.com/mysql/string-functions/mysql-rlike-function.php</a>
<a href="https://dev.mysql.com/doc/refman/8.0/en/regexp.html#operator_regexp" rel="nofollow noreferrer">https://dev.mysql.com/doc/refman/8.0/en/regexp.html#operator_regexp</a>

blocks|key|1984072|text|由于前面提到了开始和结束不应该是元音的要求，在这里我们可以使用RLIKE的模式：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1984073|从车站选择不同的城市(左(城市，1)不在('a'，'e'，'i'，'o'，'u')，右边(城市，1)不在('a'，'e'，'i'，‘o，’u‘)；|1984074|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

As the requirement is mentioned that the start and end should not be Vowel, here we can use a Pattern using RLIKE:

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'));

blocks|key|717521|text|mysql|type|unstyled|depth|inlineStyleRanges|entityRanges|data|717522|回答“不以元音开头，也不以元音结尾”的回答是选择不同的城市与非城市的城市“%5EAEIOUaeiou”或“非城市的城市”“.*AEIOUaeiou$”；|717523|回答“不以元音开头，不以元音结尾”的回答是选择不同的城市，从非城市的城市“%5E.*AEIOUaeiou$”和“非城市的城市”选择不同的城市；|717524|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

mysql

Answer for "dont start with vowels either dont end with vowels" is
SELECT DISTINCT CITY FROM STATION 
WHERE NOT CITY RLIKE '^[AEIOUaeiou]' or NOT CITY RLIKE '.*[AEIOUaeiou]$' ;

Answer for "dont start with vowels and dont end with vowels" is
SELECT DISTINCT CITY FROM STATION 
WHERE NOT CITY RLIKE '^[AEIOUaeiou]' And NOT CITY RLIKE '.*[AEIOUaeiou]$' ;

blocks|key|717554|text|对于甲骨文来说，试试这个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|717555|SELECT+DISTINCT+CITY+FROM+STATION+WHERE+REGEXP_LIKE(CITY,'%5E.*[%5EaeiouAEIOU]$')+
UNION+
SELECT+DISTINCT+CITY+FROM+STATION+WHERE+REGEXP_LIKE(CITY,'%5E[%5EaeiouAEIOU].*$');|code-block|syntax|javascript|717556|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

for oracle try this:

<pre><code>SELECT DISTINCT CITY FROM STATION WHERE REGEXP_LIKE(CITY,'^.*[^aeiouAEIOU]$') 
UNION 
SELECT DISTINCT CITY FROM STATION WHERE REGEXP_LIKE(CITY,'^[^aeiouAEIOU].*$');
</code></pre>

blocks|key|1984229|text|从城市不喜欢'%25a‘和不喜欢'%25i’的城市和不喜欢'%25e‘的城市和不喜欢'%25o’的城市和不喜欢‘%25u’的城市中选择不同的城市；|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1984230|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

SELECT DISTINCT CITY FROM STATION WHERE CITY NOT like '%a' and CITY NOT like '%i'
and CITY NOT like '%e' and CITY NOT like '%o' and CITY NOT like '%u';

blocks|key|994809|text|甲骨文：select+DISTINCT+CITY+FROM+STATION+WHERE+REGEXP_LIKE(CITY,'%5E[%5Eaeiou]%7C[%5Eaeiou]$','i');|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|994810|entityMap^0|4|2C|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

For Oracle : <code>select DISTINCT CITY FROM STATION WHERE REGEXP_LIKE(CITY,'^[^aeiou]|[^aeiou]$','i');</code>

blocks|key|717699|text|简单的MySql查询可以类似于：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|717700|SELECT+DISTINCT+CITY+FROM+STATION+WHERE+CITY+NOT+REGEXP+'%5E[aeiou].*[aeiou]$';|code-block|syntax|javascript|717701|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Simple MySql query can be like :
<pre><code>SELECT DISTINCT CITY FROM STATION WHERE CITY NOT REGEXP '^[aeiou].*[aeiou]$';
</code></pre>

blocks|key|995400|text|我的SQL查询：|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|995401|SELECT+DISTINCT+CITY+FROM+STATION+
WHERE(CITY+NOT+LIKE+'u%25'+AND+
CITY+NOT+LIKE+'a%25'+AND+
CITY+NOT+LIKE+'e%25'+AND+
CITY+NOT+LIKE+'i%25'+AND+
CITY+NOT+LIKE+'o%25')+OR
(+CITY+NOT+LIKE+'%25u'+AND+
CITY+NOT+LIKE+'%25a'+AND+
CITY+NOT+LIKE+'%25e'+AND+
CITY+NOT+LIKE+'%25i'+AND+
CITY+NOT+LIKE+'%25o');|code-block|syntax|javascript|995402|entityMap^0|0|8|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

My SQL Query:
<pre><code>SELECT DISTINCT CITY FROM STATION 
WHERE(CITY NOT LIKE 'u%' AND 
CITY NOT LIKE 'a%' AND 
CITY NOT LIKE 'e%' AND 
CITY NOT LIKE 'i%' AND 
CITY NOT LIKE 'o%') OR
( CITY NOT LIKE '%u' AND 
CITY NOT LIKE '%a' AND 
CITY NOT LIKE '%e' AND 
CITY NOT LIKE '%i' AND 
CITY NOT LIKE '%o');
</code></pre>

blocks|key|717835|text|对于MySQL|type|unstyled|depth|inlineStyleRanges|entityRanges|data|717836|SELECT+DISTINCT+CITY
FROM+STATION
WHERE+CITY+REGEXP+"%5E[%5EaeiouAEIOU].*[%5EaeiouAEIOU]$"|code-block|syntax|javascript|717837|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

for MySQL
<pre><code>SELECT DISTINCT CITY
FROM STATION
WHERE CITY REGEXP &quot;^[^aeiouAEIOU].*[^aeiouAEIOU]$&quot;
</code></pre>

blocks|key|717877|text|这个是针对MySQL的，刚刚试过了，而且它的工作原理。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|717878|SELECT+DISTINCT+CITY
FROM+STATION
WHERE+CITY+NOT+RLIKE+'%5E[aeiou]'
OR+CITY+NOT+REGEXP+'[aeiou]$'|code-block|syntax|javascript|717879|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This one is for MySQL, just tried now, and its works.
<pre><code>SELECT DISTINCT CITY
FROM STATION
WHERE CITY NOT RLIKE '^[aeiou]'
OR CITY NOT REGEXP '[aeiou]$'
</code></pre>

blocks|key|994853|text|SELECT+DISTINCT+CITY+FROM+STATION+WHERE+lower(right(CITY,1))+not+in('a','e','i','o','u');|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|994854|表示城市不以元音结尾|BOLD|994855|entityMap^0|0|2H|0|0|8|0^^$0|@$1|2|3|4|5|6|7|K|8|@$9|L|A|M|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|N|8|@$9|O|A|P|B|H]]|D|@]|E|$]]|$1|I|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|J|$]]

<code>SELECT DISTINCT CITY FROM STATION WHERE lower(right(CITY,1)) not in('a','e','i','o','u');</code>
For City not ending with vowel

blocks|key|1984435|text|SELECT+DISTINCT+CITY+FROM+STATION+
WHERE+CITY+REGEXP+'%5E[%5Eaeiou]'+/*Checks+City+does+not+start+with+vowel*/
AND++CITY+REGEXP+'[%5Eaeiou]$';+/*Checks+City+does+not+end+with+vowel*/|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1984436|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>SELECT DISTINCT CITY FROM STATION 
WHERE CITY REGEXP '^[^aeiou]' /*Checks City does not start with vowel*/
AND CITY REGEXP '[^aeiou]$'; /*Checks City does not end with vowel*/
</code></pre>

blocks|key|1984441|text|简单明了的回答：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1984442|select+distinct++city+
from+station+
where+city+regexp+'%5E[%5Eaeiou].*[%5Eaeiou]$'|code-block|syntax|javascript|1984443|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Simple and clean answer:
<pre><code>select distinct city 
from station 
where city regexp '^[^aeiou].*[^aeiou]$'
</code></pre>

blocks|key|994656|text|在MySQL中，正则表达式与Python中的正则表达式相同。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|994657|在这种情况下，您也可以使用正则表达式。|994658|选择以元音开头和结尾的城市。|ordered-list-item|994659|接下来，把而不是放在前面，这将消除这些城市。|offset|length|style|BOLD|994660|查询内容如下：|994661|select+distinct(city)+from+station+where+not+(city+rlike+'%5E[aeiouAEIOU]'+and+city+rlike+'[aeiouAEIOU]$');|code-block|syntax|javascript|994662|entityMap^0|0|0|0|5|3|0|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|W|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|X|8|@]|9|@]|A|$]]|$1|G|3|H|5|F|7|Y|8|@$I|Z|J|10|K|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|11|8|@]|9|@]|A|$]]|$1|O|3|P|5|Q|7|12|8|@]|9|@]|A|$R|S]]|$1|T|3|-4|5|6|7|13|8|@]|9|@]|A|$]]]|U|$]]

In MySQL regular expressions are the same as in Python.

You can use regular expressions in this case as well.

<ol>
<li>Select the cities which start and end with vowels.</li>
<li>Next, put not in front, which will eliminate those cities.</li>
</ol>

The query will be:

<pre><code>select distinct(city) from station where not (city rlike '^[aeiouAEIOU]' and city rlike '[aeiouAEIOU]$');
</code></pre>

blocks|key|1984065|text|SELECT+DISTINCT+CITY+
FROM+STATION+
WHERE+SUBSTR(CITY,1,1)+NOT+IN+('A','E','I','O','U')+OR
++++++SUBSTR(CITY,-1,1)+NOT+IN+('a','e','i','o','u');|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1984066|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>SELECT DISTINCT CITY 
FROM STATION 
WHERE SUBSTR(CITY,1,1) NOT IN ('A','E','I','O','U') OR
 SUBSTR(CITY,-1,1) NOT IN ('a','e','i','o','u');
</code></pre>

Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.
Input Format
The STATION table is described as follows:
<img src="https://i.stack.imgur.com/ijZ2W.png" alt="enter image description here" />
I write the below query, but it's not working for me. Any suggestion?
<pre><code>select distinct city
from station
where city regexp '^[^aeiou].*[^aeiou]$'; 
</code></pre>

Get city name either do not start with vowels or do not end with vowels

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

从站点查询不以元音开头或不以元音结尾的城市名称列表。您的结果不能包含重复项。输入格式所述车站表如下：​​我编写了下面的查询，但它不适合我。有什么建议吗？select distinct cityfrom stationwhere city regexp '^[^aeiou].*[^aeiou]$'; 

问不要以元音开头，也不要以元音结尾。
EN

回答 48

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问不要以元音开头，也不要以元音结尾。EN

回答 48

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问不要以元音开头，也不要以元音结尾。
EN