假设您正在使用MySQL,这就是您要寻找的东西
SELECt DISTINCT city FROM station WHERe city RLIKE'^[^aeiouAEIOU].*|.*[^AEIOUaeiou]$';
Footnote : RLIKE and
DISTINCT

假设您正在使用MySQL,这就是您要寻找的东西
SELECt DISTINCT city FROM station WHERe city RLIKE'^[^aeiouAEIOU].*|.*[^AEIOUaeiou]$';
Footnote : RLIKE and
DISTINCT