not like [a-z]

[simonbc]

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

[Anon]

try something like this:

SELECT * FROM foobar WHERE foo NOT REGEXP '[a-zA-Z]{1,1}';

thats kind of a guess - try it out or go to http://mysql.com/documentation/ and do a search for REGEXP

post back if it works too 🙂

[simonbc]

Here's the solution to my problem (went and got it at mysql.com/documentation):

SELECT * FROM foobar WHERE foo NOT REGEXP "^[a-zA-Z]";

The '^' made the trick...