mySQL Query Question

[Patrick Lucas]

Hello,
I have a simple mySQL table with the following columns: id and artist_id


The ID column is the primary key. Is there anyway I can select all of the artist_id columns, but not have any of them repeat?

Hope that makes sense


Thanks!

[redemption]

SELECT DISTINCT artist_id FROM your_tablename;

[Patrick Lucas]

Ah. Hoped it'd be simple. Thanks!

[Patrick Lucas]

Now... Is there any easy way to order the results by occurrence?

[DR_LaRRY_PEpPeR]

you mean count each artist_id and sort them from most to least? this will do that:

SELECT COUNT(*) AS count, artist_id FROM table GROUP BY artist_id ORDER BY count DESC