Help with MySQL Query for removing dupes

webosb

I have 3 fields: id, rating, and ip

sample format:

id | rating | ip
1 | 10 | 1.2.3.4
1 | 10 | 1.2.3.4
1 | 10 | 1.2.3.4
1 | 10 | 1.2.3.4
1 | 10 | 1.3.2.4
1 | 10 | 1.1.2.2

I need a query to remove all duplicate ips for rating 10 for id 1 so the above sample will end up like this:

id | rating | ip
1 | 10 | 1.2.3.4
1 | 10 | 1.3.2.4
1 | 10 | 1.1.2.2

please note that id ranges from 1-1000 and rating ranges anywhere from 1 to 10 so I need a query to remove dupe ip's from ratings 1-10 for each id

NogDog

I can't think of a simple way. I suppose I'd probably try to do a SELECT DISTINCT into a temporary table, TRUNCATE the main table, then copy the temp table into the (now empty) main table. I'd also make sure that there is a unique index defined for that combination of 3 columns, so that no more duplicates get entered.