need help finding distinct records

[wil831]

i have columns unique_id, artist and title.
if "id1 = coldplay - song1", "id2 = coldplay - song2", "id3 = coldplay - song1" then id1 and id3 are duplicates but not id2..
how would i use a mysql query to do this?

[barand]

how would i use a mysql query to do this?

Not entirely sure what this is, so I can think of 3 possibilities

1. You want to list all ids but only once, even if there are duplicates

2. You want to list on those that are not duplicated

3. You want to know which ones are duplicated
   [/list=1]

   $sql1 = "SELECT DISTINCT unique_id FROM table";

   $sql2 = "SELECT unique_id, COUNT(unique_id) as idcount
   FROM table
   GROUP BY unique_id
   HAVING idcount = 1";

   $sql3 = "SELECT unique_id, COUNT(unique_id) as idcount
   FROM table
   GROUP BY unique_id
   HAVING idcount > 1";

   hth

[wil831]

sorry for the confusion.
if i have 3 columns: unique_id, artist, title

it'll only show unique_id's where artist AND title are the same.

[barand]

Change queries to

$sql1 = "SELECT DISTINCT artist, title FROM table";

$sql2 = "SELECT artist, title , COUNT(unique_id) as idcount
FROM table
GROUP BY artist, title
HAVING idcount = 1";

$sql3 = "SELECT artist, title , COUNT(unique_id) as idcount
FROM table
GROUP BY artist, title
HAVING idcount > 1";

hth