您的第二个查询可以工作--因为逗号不会出现在名称的开头或结尾。
在所有的可能性。所需的解决方案是一个单一的模式：

where city like '[^aeiou]%[^aeiou]'

select distinct city
from station
where city rlike '^[^aeiouAEIOU].*' and city rlike '^.*[^aeiouAEIOU]$'

试试这个：

SELECT DISTINCT CITY  FROM STATION  WHERE UPPER(SUBSTR(CITY, 1, 1)) NOT IN ('A', 'E', 'I', 'O', 'U')
     AND UPPER(SUBSTR(C.CITY, LENGTH(CITY), 1)) NOT IN ('A', 'E', 'I', 'O', 'U')

尝试MySQL解决方案：

select distinct CITY from STATION where substr(CITY, 1, 1) not in ('a','e','i','o','u') and substr(CITY, -1, 1) not in ('a','e','i','o','u');

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%' ORDER BY City

解决方案如下：

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

SELECT DISTINCT CITY 
FROM STATION 
WHERE LOWER(RIGHT(CITY,1)) NOT IN ('a', 'e', 'i', 'o', 'u') AND 
      LOWER(LEFT(CITY,1)) NOT IN ('a', 'e', 'i', 'o', 'u');

给予一下下面的代码

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

使用基本的LIKE语句来选择第一个字母，在这里，我使用NOT LIKE来排除元音。

SELECT DISTINCT city
FROM station
WHERE LOWER(city) NOT LIKE 'a%'
AND LOWER(city) NOT LIKE 'e%'
AND LOWER(city) NOT LIKE 'i%'
AND LOWER(city) NOT LIKE 'o%'
AND LOWER(city) NOT LIKE 'u%';