blocks|key|2193294|text|我不是DB2方面的专家，但我认为你可以在你喜欢的地方使用正则表达式。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2193295|查看文档：https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0061494.html|offset|length|2193296|Example:
Select+Distinct+city
From+++station
Where++REGEXP_LIKE(city,'[aeiou].*[aeiou]')|code-block|syntax|javascript|2193297|entityMap|0|LINK|mutability|MUTABLE|url|https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0061494.html^0|0|5|2Y|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@$D|U|E|V|1|W]]|A|$]]|$1|F|3|G|5|H|7|X|8|@]|9|@]|A|$I|J]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

I'm not an expert in DB2, but I think you can use a regular expression in your WHERE LIKE.

Check the documentation:
<a href="https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0061494.html" rel="nofollow noreferrer">https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0061494.html</a>

<pre><code>Example:
Select Distinct city
From station
Where REGEXP_LIKE(city,'[aeiou].*[aeiou]')
</code></pre>

blocks|key|3157660|text|在LIKE子句中使用正则表达式。请看这里的示例Using+RegEx+in+SQL+Server|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3157661|在Sql+server中，LIKE子句可能如下所示。|3157662|就像'AEIOU%25aeiou‘|3157663|在DB2中，语法略有不同。在这一页上看几个例子。|3157664|https://www.ibm.com/developerworks/data/library/techarticle/0301stolze/0301stolze.html|3157665|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/8928378/using-regex-in-sql-server|1^0|N|P|0|0|0|0|0|0|2E|1|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@$A|V|B|W|1|X]]|C|$]]|$1|D|3|E|5|6|7|Y|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|Z|8|@]|9|@]|C|$]]|$1|H|3|I|5|6|7|10|8|@]|9|@]|C|$]]|$1|J|3|K|5|6|7|11|8|@]|9|@$A|12|B|13|1|14]]|C|$]]|$1|L|3|-4|5|6|7|15|8|@]|9|@]|C|$]]]|M|$N|$5|O|P|Q|C|$R|S]]|T|$5|O|P|Q|C|$R|K]]]]

Use regular expressions in your LIKE clause. Look at the example here <a href="https://stackoverflow.com/questions/8928378/using-regex-in-sql-server">Using RegEx in SQL Server</a>

In Sql server your LIKE clause might look like this.

LIKE '[AEIOU]%[aeiou]'

In DB2 the syntax is slightly different. Look few examples down on this page.

<a href="https://www.ibm.com/developerworks/data/library/techarticle/0301stolze/0301stolze.html" rel="nofollow noreferrer">https://www.ibm.com/developerworks/data/library/techarticle/0301stolze/0301stolze.html</a>

blocks|key|286495|text|我不是DB2专家，但这应该是相当可移植的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|286496|WHERE+LEFT(city,1)+IN+('A',+'E',+'I',+'O',+'U')
++AND+RIGHT(city,1)+IN+('a',+'e',+'i',+'o',+'u')|code-block|syntax|javascript|286497|您可能希望将其全部标准化为大写，以避免由于某种原因而以小写字母开头或以大写字母结尾的城市出现问题。|286498|WHERE+UPPER(LEFT(city,1))+IN+('A',+'E',+'I',+'O',+'U')
++AND+LOWER(RIGHT(city,1))+IN+('a',+'e',+'i',+'o',+'u')|286499|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|$]]

I am not a DB2 expert but this should be fairly portable:

<pre><code>WHERE LEFT(city,1) IN ('A', 'E', 'I', 'O', 'U')
 AND RIGHT(city,1) IN ('a', 'e', 'i', 'o', 'u')
</code></pre>

You may want to normalize it all to upper case to avoid problems with cities that for some reason start with a lower case letter or end with an upper case letter.

<pre><code>WHERE UPPER(LEFT(city,1)) IN ('A', 'E', 'I', 'O', 'U')
 AND LOWER(RIGHT(city,1)) IN ('a', 'e', 'i', 'o', 'u')
</code></pre>

blocks|key|5268972|text|作为一个初学者，我是这样解决这个问题的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5268973|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';|code-block|syntax|javascript|5268974|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|$]]

As a beginner, this is how I solved it:

<pre><code>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>

blocks|key|5268976|text|您可以像这样使用substr：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|5268977|SELECT+DISTINCT+CITY+
FROM+STATION+WHERE+SUBSTR(CITY,1,1)+IN('A','E','I','O','U','a','e','i','o','u')+
and+SUBSTR(CITY,-1,1)+IN('A','E','I','O','U','a','e','i','o','u');|code-block|syntax|javascript|5268978|entityMap^0|8|6|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|$]]

You could use <code>substr</code> like this:

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

blocks|key|2199704|text|从REGEXP_LIKE(城市，‘%5E%5Eaeiouaeiou.*’)所在的站点中选择不同的城市；|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2199705|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 REGEXP_LIKE(CITY,'^[^aeiouAEIOU].*');

blocks|key|2199707|text|尝试执行以下操作：(Oracle)从REGEXP_LIKE(城市，‘%5E%5EaeiouAEIO.*’)所在的站点中选择不同的城市；|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2199708|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|$]]

Try the following:(oracle)
SELECT DISTINCT CITY FROM STATION WHERE REGEXP_LIKE(CITY,'^[^aeiouAEIOU].*');

blocks|key|5268993|text|您可以在MySQL中使用REGEXP来操作正则表达式|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|CODE|entityRanges|data|5268994|SELECT+DISTINCT+city+
FROM+station+
WHERE+city+REGEXP+'%5E[aeiou].*[aeiou]$';|code-block|syntax|javascript|5268995|对于不熟悉正则表达式的人|5268996|%5E[aeiou]++++//+Start+with+a+vowel
.*++++++++++//+Any+characters+at+any+times
[aeiou]$++++//+End+with+a+vowel|5268997|entityMap^0|4|5|L|5|C|6|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@$9|S|A|T|B|C]|$9|U|A|V|B|C]|$9|W|A|X|B|D]]|E|@]|F|$]]|$1|G|3|H|5|I|7|Y|8|@]|E|@]|F|$J|K]]|$1|L|3|M|5|6|7|Z|8|@]|E|@]|F|$]]|$1|N|3|O|5|I|7|10|8|@]|E|@]|F|$J|K]]|$1|P|3|-4|5|6|7|11|8|@]|E|@]|F|$]]]|Q|$]]

You can use <code>REGEXP</code> in MySQL to operate Regular Expression
<pre><code>SELECT DISTINCT city 
FROM station 
WHERE city REGEXP '^[aeiou].*[aeiou]$';
</code></pre>
For people who don't familiar with Regular Expression
<pre><code>^[aeiou] // Start with a vowel
.* // Any characters at any times
[aeiou]$ // End with a vowel
</code></pre>

blocks|key|285272|text|这将在SQL+Server中使用AND子句在3行中回答-|type|unstyled|depth|inlineStyleRanges|entityRanges|data|285273|SELECT+DISTINCT+CITY+FROM+*TableName*+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')+
AND+
(city+like+'%25a'+or+city+like+'%25e'+or+city+like+'%25i'+or+city+like+'%25o'+or+city+like+'%25u');|code-block|syntax|javascript|285274|..。|285275|此外，对于MySQL，您可以使用正则表达式，因为-|285276|SELECT+DISTINCT+city
FROM+++station
WHERE++city+RLIKE+'%5E[aeiouAEIOU].*[aeiouAEIOU]$'|285277|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|S|8|@]|9|@]|A|$E|F]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

This will be answerable in SQL Server in 3 lines with an AND clause-
<pre><code>SELECT DISTINCT CITY FROM *TableName* WHERE
(city like 'a%' or city like 'e%' or city like 'i%' or city like 'o%' or city like 'u%') 
AND 
(city like '%a' or city like '%e' or city like '%i' or city like '%o' or city like '%u');
</code></pre>
...
Also, you can use Regex in case of MySQL as-
<pre><code>SELECT DISTINCT city
FROM station
WHERE city RLIKE '^[aeiouAEIOU].*[aeiouAEIOU]$'
</code></pre>

blocks|key|286525|text|select+distinct+city+from+station+where+REGEXP_LIKE(city,'[aeiou]$');|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|286526|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 REGEXP_LIKE(city,'[aeiou]$');
</code></pre>

blocks|key|5269039|text|对于Oracle，，您可以这样写：|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|CODE|entityRanges|data|5269040|SELECT+*+FROM(
++++SELECT+UNIQUE(city)+FROM+station+WHERE
++++LOWER(SUBSTR(city,1,1))+IN+('a','e','i','o','u')
++++INTERSECT++
++++SELECT+UNIQUE(city)+FROM+station+WHERE
++++LOWER(SUBSTR(city,LENGTH(city),1))+IN+('a','e','i','o','u')
);|code-block|syntax|javascript|5269041|entityMap^0|2|6|2|6|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@$9|O|A|P|B|C]|$9|Q|A|R|B|D]]|E|@]|F|$]]|$1|G|3|H|5|I|7|S|8|@]|E|@]|F|$J|K]]|$1|L|3|-4|5|6|7|T|8|@]|E|@]|F|$]]]|M|$]]

For <code>Oracle</code>, you can write this-
<pre><code>SELECT * FROM(
 SELECT UNIQUE(city) FROM station WHERE
 LOWER(SUBSTR(city,1,1)) IN ('a','e','i','o','u')
 INTERSECT 
 SELECT UNIQUE(city) FROM station WHERE
 LOWER(SUBSTR(city,LENGTH(city),1)) IN ('a','e','i','o','u')
);
</code></pre>

i wrote this code (db2) and it works just fine, but i'm wondering, is there a shorter way to write this?

<pre><code>Select Distinct city
From station
Where city Like 'A%a'
 Or city Like 'A%e'
 Or city Like 'A%i'
 Or city Like 'A%o'
 Or city Like 'A%u'
 Or city Like 'E%a'
 Or city Like 'E%e'
 Or city Like 'E%i'
 Or city Like 'E%o'
 Or city Like 'E%u'
 Or city Like 'I%a'
 Or city Like 'I%e'
 Or city Like 'I%i'
 Or city Like 'I%o'
 Or city Like 'I%u'
 Or city Like 'O%a'
 Or city Like 'O%e'
 Or city Like 'O%i'
 Or city Like 'O%o'
 Or city Like 'O%u'
 Or city Like 'U%a'
 Or city Like 'U%e'
 Or city Like 'U%i'
 Or city Like 'U%o'
 Or city Like 'U%u';
</code></pre>

SQL query city names starting And ending with vowels

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

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

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

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

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

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

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

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我写了这段代码(db2)，它工作得很好，但我想知道，有没有一种更短的方法来写这段代码？Select Distinct cityFrom   stationWhere  city Like 'A%a'       Or city Like 'A%e'       Or city Like 'A%i'       Or c...

问SQL查询以元音开头和结尾的城市名称
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL查询以元音开头和结尾的城市名称EN