我想打印所有不以元音开头的城市,它们也不能以元音结尾。我知道,当它不能以一个特定的字母开头时,有很多关于如何做它的教程。但我找不到它,只表达了几封信。select distinct citywhere city not like '%[aeiou]%';where city not like '%a'where c
任务是列出站(Tablename)中不以元音开头或不以元音结尾的城市(列)名称。我用子串函数来解决它。下面的代码在MySQL服务器上完成了任务,但在MySQL上给出了不同的输出。1,1) NOT IN ('A','E','I','O','U')OR
SUBSTRING(LOWER(CITY),-1,1) NOT IN ('a','e','
这是来自的mysqlselect distinct city from station where city not regexp '^[aeiou]' and city not regexp '[aeiou]$'select distinct city from station where city not regexp '^[aeiouAEIOU].*[aeiouAEIOU]$'