用于检查名称是否以元音开头和结尾的 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屋！