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.
I don't think like support regular expressions, use regexp instead.
WHERE col_name REGEXP '[^a-z].*'
WHERE col_name NOT REGEXP '[a-z].*'