喜欢'[！a-z]％'不起作用

Question

I create a filter and i have a "#" link. I would like to have all the results except with letters. How to do that ? When i do that :

$as = "a"; // "a" link text
... LIKE '$a%'

return all matches which starts with "a" but when i do that :

... LIKE '[!a-z]%'
// or
... NOT LIKE '[a-z]%'

It not work. It should return the results without the first letters A to Z but It nothing in return.

Answer 1

I don't think like support regular expressions, use regexp instead.

WHERE col_name REGEXP '[^a-z].*'

WHERE col_name NOT REGEXP '[a-z].*'