blocks|key|664305|text|尝尝这个。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|664306|SELECT+DISTINCT+CITY+
FROM+STATION+
WHERE+CITY+NOT+RLIKE+'%5E[aeiouAEIOU].*$'|code-block|syntax|javascript|664307|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 RLIKE '^[aeiouAEIOU].*$'
</code></pre>

blocks|key|516678|text|正则表达式中的%5E可能有不同的含义，这取决于它的位置。当它是正则表达式中的第一个字符时，它指的是字符串的开头。但是，当它是一组中的第一个字符时，比如[%5Eabc]，它的意思是not+one+of。当它出现在其他地方时，它只是指%5E本身。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|516679|所以你需要这样的东西：|516680|SELECT+DISTINCT+CITY+FROM+STATION+
WHERE+CITY+RLIKE+'%5E[bcdfghjklmnpqrstvwxyzBCDFGHJKLMNPQRSTVWXYZ].*';|code-block|syntax|javascript|516681|或者，把你不想要的字母排除在外：|516682|SELECT+DISTINCT+CITY+FROM+STATION+
WHERE+CITY+RLIKE+'%5E[%5EaeiouAEIOU].*';|516683|entityMap^0|7|1|21|6|2D|A|33|1|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]|$9|V|A|W|B|C]|$9|X|A|Y|B|C]|$9|Z|A|10|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|11|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|12|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|13|8|@]|D|@]|E|$]]|$1|O|3|P|5|J|7|14|8|@]|D|@]|E|$K|L]]|$1|Q|3|-4|5|6|7|15|8|@]|D|@]|E|$]]]|R|$]]

A <code>^</code> in regular expressions can have different meanings, depending on its location. When it's the first character in a regex, it refers to the start of the string. But when it's the first character in a set, like <code>[^abc]</code>, it means <code>not one of</code>. And when it appears elsewhere, it just refers to the <code>^</code> itself.

So you would need something like:

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

or, just exclude the letters you don't want:

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

blocks|key|663040|text|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';|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|663041|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 '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|663043|text|select+distinct+city+from+station+where
city+not+in
(select+distinct+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"
));|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|663044|我想这会管用的。|unstyled|663045|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 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%"
));
</code></pre>

This will work i guess.

blocks|key|1270716|text|这在MS+SQL+SERVER上有效：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1270717|select+distinct+city+from+station+where+city+NOT+like+'[aeuio]%25'+Order+by+City;|code-block|syntax|javascript|1270718|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 on MS SQL SERVER:

<pre><code>select distinct city from station where city NOT like '[aeuio]%' Order by City;
</code></pre>

blocks|key|1270732|text|在中：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1270733|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';|code-block|syntax|javascript|1270734|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|$]]

In MS SQL:

<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%';
</code></pre>

blocks|key|1270756|text|您可以使用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1270757|select+distinct+city+from+station+where+city++not+RLIKE+'%5E[aeiouAEIOU]'|code-block|syntax|javascript|1270758|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|$]]

You can use:

<pre><code>select distinct city from station where city not RLIKE '^[aeiouAEIOU]'
</code></pre>

blocks|key|664359|text|select+distinct+city+from+station+where+city+regexp
'%5E[%5Eaeiou].*[%5Eaeiou]$'|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|664360|如果查询不以元音开头并以元音结尾。|unstyled|664361|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>

If your query doesn't starts and ends with a vowel.

blocks|key|1270791|text|select+DISTINCT+CITY+from+STATION+where+CITY+NOT+LIKE+'[a,e,i,o,u]%25'|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1270792|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 '[a,e,i,o,u]%'
</code></pre>

blocks|key|663061|text|试试这个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|663062|SELECT+DISTINCT+CITY+FROM+STATION+WHERE
LOWER(SUBSTR(CITY,LENGTH(CITY),1))+IN+('a','e','i','o','u');|code-block|syntax|javascript|663063|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 one:

<pre><code>SELECT DISTINCT CITY FROM STATION WHERE
LOWER(SUBSTR(CITY,LENGTH(CITY),1)) IN ('a','e','i','o','u');
</code></pre>

blocks|key|1270801|text|从STATION查询不以元音开头或不以元音结尾的城市名称列表。在甲骨文|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1270802|select+distinct+city+
from+station+
where+regexp_like(city,+'%5E[%5EaeiouAEIOU]%7C*[%5EaeiouAEIOU]$');|code-block|syntax|javascript|1270803|在MySQL中-|1270804|+select+distinct+city+
+from+station+
+where+city+RLIKE+'%5E[%5EaeiouAEIOU].*'+OR+
+city+RLIKE+'%5E.*[%5EaeiouAEIOU]$';|1270805|entityMap^0|1|7|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|$]]

Query the list of CITY names from <code>STATION</code> that either do not start with vowels or do not end with vowels. IN ORACLE

<pre><code>select distinct city 
from station 
where regexp_like(city, '^[^aeiouAEIOU]|*[^aeiouAEIOU]$');
</code></pre>

In MySQL - 

<pre><code> select distinct city 
 from station 
 where city RLIKE '^[^aeiouAEIOU].*' OR 
 city RLIKE '^.*[^aeiouAEIOU]$';
</code></pre>

blocks|key|1270833|text|尝试以下几点：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1270834|SELECT+DISTINCT+CITY+FROM+STATION
WHERE+CITY+REGEXP+'%5E[%5Eaeiou].*';|code-block|syntax|javascript|1270835|MySQL参考文献：https://dev.mysql.com/doc/refman/5.5/en/regexp.html|offset|length|1270836|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/doc/refman/5.5/en/regexp.html^0|0|0|A|1F|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

Try the following:

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

MySQL Ref.: <a href="https://dev.mysql.com/doc/refman/5.5/en/regexp.html" rel="nofollow noreferrer">https://dev.mysql.com/doc/refman/5.5/en/regexp.html</a>

blocks|key|663073|text|Select+Distinct+City+from+Station+where+City+Like+'[%5Eaeiou]%25';|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|663074|测试了MS+SQL+Server。|unstyled|663075|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 Like '[^aeiou]%';
</code></pre>

MS SQL Server Tested.

blocks|key|663077|text|神谕|type|unstyled|depth|inlineStyleRanges|entityRanges|data|663078|select+distinct+
++++city+
from+station+
where+regexp_like(city,+'%5E[%5EaeiouAEIOU].*');|code-block|syntax|javascript|663079|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 

<pre><code>select distinct 
 city 
from station 
where regexp_like(city, '^[^aeiouAEIOU].*');
</code></pre>

blocks|key|516843|text|没有正则表达式的简单示例|type|unstyled|depth|inlineStyleRanges|entityRanges|data|516844|SELECT+DISTINCT+
++++City+
FROM+Station
WHERE+LEFT(City,+1)+NOT+IN+("a",+"e",+"i",+"o",+"u");|code-block|syntax|javascript|516845|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 example without regular expressions

<pre><code>SELECT DISTINCT 
 City 
FROM Station
WHERE LEFT(City, 1) NOT IN ("a", "e", "i", "o", "u");
</code></pre>

blocks|key|663103|text|+SELECT+DISTINCT+city+from+STATION
+WHERE+city+NOT+LIKE+"[aieuo]%25[aieuo]+[aieuo]%25[aieuo]"
+AND+city+NOT+LIKE+"[aieuo]%25[aieuo]";|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|663104|第一个不喜欢的意思是，两个词的城市名称的每个单词都不以元音开头和结尾。第二个不喜欢的是一个词的城市名称。|unstyled|663105|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 NOT LIKE "[aieuo]%[aieuo] [aieuo]%[aieuo]"
 AND city NOT LIKE "[aieuo]%[aieuo]";
</code></pre>

The first NOT LIKE means, that each word of the two-word city names doesn't start and end with vowels. The second NOT LIKE is for one-word city names.

blocks|key|664422|text|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')
);|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|664423|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') 
 and 
 right(city,1) not in ('a','e','i','o','u')
);
</code></pre>

blocks|key|1270946|text|在ORACLE中：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1270947|select+
distinct(city)
from+station
where+regexp_like+(city,+'%5E[%5EA%7CE%7CI%7CO%7CU](*)');|code-block|syntax|javascript|1270948|没有必要在此解决方案中指定结束字母。在所提出的问题中，这是没有必要的。|1270949|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|$]]

In ORACLE:

<pre><code>select 
distinct(city)
from station
where regexp_like (city, '^[^A|E|I|O|U](*)');
</code></pre>

There is no need to specify the ending letter in this solution. It's not called out for in the problem presented.

blocks|key|664451|text|select+distinct+city+from+station+where+city+regexp+'%5E[%5Eaeiou].*[%5Eaeiou]$'|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|664452|distinct:以避免以下列上的重复|unstyled|offset|length|style|BOLD|664453|regexp:+MySql+function+(雷杰普)以获得正则表达式。表达式以%5E开头，以$结尾。在甲骨文中它的regexp_like+(city,'RegEx')+使用Oracle数据库的正则表达式。|CODE|664454|[%5E...]是指不包含任何...的字符。|664455|[%5E...].是指不包含任何...的单个字符。|664456|[%5E...].*的意思是第一个字符不包含任何...|664457|[%5E...].*[%5E...]的意思是第一个字符不包含任何...，也不以...结尾。|664458|[%5Eaeiou].*[%5Eaeiou]指的是第一个字符不以元音开头，也不以元音结尾。|664459|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/doc/refman/8.0/en/regexp.html|1|https://docs.oracle.com/cd/B13789_01/appdev.101/b10795/adfns_re.htm^0|0|0|9|0|0|7|15|1|1A|1|1L|Q|O|3|0|2C|H|1|0|0|6|D|3|0|0|7|E|3|0|0|8|M|3|0|0|E|S|3|Z|3|0|0|I|0^^$0|@$1|2|3|4|5|6|7|17|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|18|8|@$G|19|H|1A|I|J]]|9|@]|A|$]]|$1|K|3|L|5|F|7|1B|8|@$G|1C|H|1D|I|J]|$G|1E|H|1F|I|M]|$G|1G|H|1H|I|M]|$G|1I|H|1J|I|M]]|9|@$G|1K|H|1L|1|1M]|$G|1N|H|1O|1|1P]]|A|$]]|$1|N|3|O|5|F|7|1Q|8|@$G|1R|H|1S|I|M]|$G|1T|H|1U|I|M]]|9|@]|A|$]]|$1|P|3|Q|5|F|7|1V|8|@$G|1W|H|1X|I|M]|$G|1Y|H|1Z|I|M]]|9|@]|A|$]]|$1|R|3|S|5|F|7|20|8|@$G|21|H|22|I|M]|$G|23|H|24|I|M]]|9|@]|A|$]]|$1|T|3|U|5|F|7|25|8|@$G|26|H|27|I|M]|$G|28|H|29|I|M]|$G|2A|H|2B|I|M]]|9|@]|A|$]]|$1|V|3|W|5|F|7|2C|8|@$G|2D|H|2E|I|M]]|9|@]|A|$]]|$1|X|3|-4|5|F|7|2F|8|@]|9|@]|A|$]]]|Y|$Z|$5|10|11|12|A|$13|14]]|15|$5|10|11|12|A|$13|16]]]]

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

distinct: to avoid the duplication on the following column 

regexp: MySql function (<a href="https://dev.mysql.com/doc/refman/8.0/en/regexp.html" rel="nofollow noreferrer">regexp</a>) to obtain Regular Expressions. expression starts with <code>^</code> and ends with <code>$</code>. In Oracle its <code>regexp_like (city,'RegEx')</code> <a href="https://docs.oracle.com/cd/B13789_01/appdev.101/b10795/adfns_re.htm" rel="nofollow noreferrer">Regular Expressions With Oracle Database</a>.

<code>[^...]</code> means any character NOT contain any of <code>...</code> 
<code>[^...].</code> means a single character NOT contain any of <code>...</code> 
<code>[^...].*</code> means first character NOT contain any of <code>...</code> 
<code>[^...].*[^...]</code> means first character NOT contains any of <code>...</code> AND not ends with <code>...</code> 
<code>[^aeiou].*[^aeiou]</code> mean the first character NOT starts with vowels AND not ends with vowels

blocks|key|517037|text|Mysql我们可以用这个。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|517038|select+distinct+city+from+station+where+city+regexp+'%5E[%5Eaeiou].*';|code-block|syntax|javascript|517039|了解有关MySQL正则表达式的更多信息|offset|length|517040|对于Oracle，我们可以使用|517041|select+distinct(city)+from+station+where+regexp_like+(city,+'%5E[%5EAEIOU](*)');|517042|了解有关Oracle正则表达式的更多信息|517043|对于MS+SQL+Server|517044|select+distinct+city+from+station+where+city+not+like+'[aeuio]%25';|517045|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/doc/refman/5.5/en/regexp.html|1|https://www.techonthenet.com/oracle/regexp_like.php^0|0|0|0|J|0|0|0|0|0|K|1|0|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|15|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|16|8|@]|9|@$I|17|J|18|1|19]]|A|$]]|$1|K|3|L|5|6|7|1A|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|1B|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|1C|8|@]|9|@$I|1D|J|1E|1|1F]]|A|$]]|$1|Q|3|R|5|6|7|1G|8|@]|9|@]|A|$]]|$1|S|3|T|5|D|7|1H|8|@]|9|@]|A|$E|F]]|$1|U|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]]|V|$W|$5|X|Y|Z|A|$10|11]]|12|$5|X|Y|Z|A|$10|13]]]]

Mysql we can use this.

<pre><code>select distinct city from station where city regexp '^[^aeiou].*';
</code></pre>

<a href="https://dev.mysql.com/doc/refman/5.5/en/regexp.html" rel="nofollow noreferrer">To Know More About MySQL Regular Expression</a>

For Oracle we can use

<pre><code>select distinct(city) from station where regexp_like (city, '^[^AEIOU](*)');
</code></pre>

<a href="https://www.techonthenet.com/oracle/regexp_like.php" rel="nofollow noreferrer">To Know More About Oracle Regular Expression</a>

For MS SQL Server

<pre><code>select distinct city from station where city not like '[aeuio]%';
</code></pre>

blocks|key|517057|text|我试过这个。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|517058|select+distinct+city
from+station
where+substring(city,1,1)+not+in('A','E','I','O','U');|code-block|syntax|javascript|517059|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 tried this.

<pre><code>select distinct city
from station
where substring(city,1,1) not in('A','E','I','O','U');
</code></pre>

blocks|key|1271060|text|我做过这个|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1271061|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'|code-block|syntax|javascript|1271062|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%'
</code></pre>

blocks|key|663181|text|select+distinct+<COLUMN+NAME>+from+<table+name>
WHERE+SUBSTRING(<COLUMN+NAME>,1,1)+not+in+('a','e','i','o','u','A','E','I','O','U')
order+by+<COLUMN+NAME>|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|663182|不同的单词不以元音开头。|unstyled|663183|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 &lt;COLUMN NAME&gt; from &lt;table name&gt;
WHERE SUBSTRING(&lt;COLUMN NAME&gt;,1,1) not in ('a','e','i','o','u','A','E','I','O','U')
order by &lt;COLUMN NAME&gt;
</code></pre>

Distinct words do not start with a vowel.

blocks|key|663185|text|SELECT+DISTINCT+city+FROM+station
WHERE+CITY+NOT+REGEXP+'%5E[aeiou]'|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|663186|MySQL接受了答案。|unstyled|663187|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 NOT REGEXP '^[aeiou]'
</code></pre>

MySQL accepted answer.

blocks|key|1271157|text|select+distinct+city+from+station+where+REGEXP_LIKE(LOWER(city),'%5E[%5Eaeiou].*.[%5Eaeiou]$');|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1271158|%5Eaeiou不接受aeiou。|unstyled|1271159|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 REGEXP_LIKE(LOWER(city),'^[^aeiou].*.[^aeiou]$');
</code></pre>

[^aeiou] Does not accept aeiou.

blocks|key|1271172|text|试试这个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1271173|SELECT+DISTINCT+CITY+
FROM+STATION+
WHERE+CITY+NOT+REGEXP+'[aeiouAEIOU]$'|code-block|syntax|javascript|1271174|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 REGEXP '[aeiouAEIOU]$'
</code></pre>

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

This is the query that I've written

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

This gives a wrong answer. What am I doing wrong here?

SQL query to find a list of city names that dont start with vowels

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

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

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

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

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

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

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

我试图从不以元音开头的表站查询城市名称列表，结果不能包含重复的结果。这张桌子上有身份证，城市，人口这是我写的查询SELECT DISTINCT CITY FROM STATION WHERE CITY RLIKE '[^bcdfghjklmnpqrstvwxyzBCDFGHJKLMNPQRSTVWXYZ].*';这给出...

问SQL查询，查找不以元音开头的城市名称列表
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL查询，查找不以元音开头的城市名称列表EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL查询，查找不以元音开头的城市名称列表
EN