Im running a query on my database that has a list of my mp3's. I want to know how many DIFFERENT albums I have (so repeats should not be counted).
I have 5 pink floyd albums, so in each row of my database I have each individual song from those albums, and in the 'album' column I have what album each song belongs to. So, I want to just fetch the 5 album names.
How would I run a query??
SELECT * ... FROM 'mp3s' WHERE ... ??
Please let me know. Much appreciated!