CODEWITHSUNDEEP
phpmysql
KD974
KD974

Reputation: 19

LIKE '[!a-z]%' not work

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.

Upvotes: 1

Views: 1015

Answers (1)

user10089632
user10089632

Reputation: 5570

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

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

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

Upvotes: 3

Related Questions