Page 1 of 1

select where first letter is a number (mysql)

Posted: Sun Aug 10, 2003 8:38 am
by snek_one
ok, now I may be an idiot for forgetting how to do this and not being able to find it in the manual or via google, but you would really help me out with this...

how do I do a select where the first letter has to be a numer? i have a list of artists which make electronic music and a couple start with a number.. i've already gotten the entire alphabet working so ppl can view only artists with a certain letter as the first letter, but numbers are something different..

thnx in advance for the help..

Posted: Sun Aug 10, 2003 11:32 am
by JAM
Not to good at this, but:

Code: Select all

SELECT * FROM table WHERE left(field,1) NOT IN ('1', '2', '3', '4', '5', '6', '7', '8', '9', '0');