I have a large list of songs and artists and I am creating a playlist. At the top, I have the user select a letter which will then direct them to artists that start with that letter.
The problem I am running into is for artists that start with a number should be going under a separate category 0-9 and '. But instead they are going as individual numbers in the list.
The query I am running for this is:
SELECT distinct substr(artist, 1,1) as browse FROM songlist WHERE songtype = "S" or songtype = "C" ORDER by artist asc
I have tried adding into the where clause AND songlist.browse not like '1%') etc.
My question is, can I run a query and exclude numbers from returning in the result?
Does anyone have any suggestions that I could use to accomplish this?
Thank you in advance to anyone who may be of help.