mysql - SQL-模式匹配无输出

Question

我必须打印不以元音开头和结尾的名称列表。我输入了以下查询:

SELECT DISTINCT NAME 
FROM STUDENT 
WHERE NAME NOT LIKE '[AEIOU]%' 
  AND NAME NOT LIKE '%[aeiou]' 
ORDER BY NAME;

它在输出屏幕上没有产生任何结果。这里有什么问题？

Answer 1

使用 RLIKE 和正则表达式:

SqlFiddleDemo

SELECT DISTINCT NAME 
FROM STUDENT 
WHERE NAME RLIKE '^[^aeouiy].*[^aeouiy]$' 
ORDER BY NAME;