not like [a-z]

admin

Administrator
Staff member
Hi!

I would like to do a select that looks something like this:

SELECT * FROM foobar WHERE foo NOT LIKE '[a-z]%';

I want to select all items that doesn't start with either A-Z nor a-z (ex: 4, !, @ etc.). How is this done?

--
Simon
 
Back
Top