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..
select where first letter is a number (mysql)
Moderator: General Moderators
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');