SQL查询以检查名称是否以元音开头和结尾 [英] SQL query to check if a name begins and ends with a vowel

问题描述

我想从表STATION(id, city, longitude, latitude)中查询CITY名称的列表，这些名称的第一个和最后一个字符都带有元音.结果不能包含重复项.

I want to query the list of CITY names from the table STATION(id, city, longitude, latitude) which have vowels as both their first and last characters. The result cannot contain duplicates.

为此，我编写了一个类似WHERE NAME LIKE 'a%'的查询，该查询具有25个条件，每个元音每个其他元音，这非常麻烦.有更好的方法吗?

For this is I wrote a query like WHERE NAME LIKE 'a%' that had 25 conditions, each vowel for every other vowel, which is quite unwieldy. Is there a better way to do it?

推荐答案

您可以使用正则表达式:

SELECT DISTINCT city
FROM   station
WHERE  city RLIKE '^[aeiouAEIOU].*[aeiouAEIOU]$'

这篇关于SQL查询以检查名称是否以元音开头和结尾的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！