[thelist] MySQL - Remove "almost" duplicates

[Stephen Rider]

>> I'm trying to remove records from a table that are identical except
>> for the "time" field.

On Aug 2, 2008, at 3:05 PM, Jeremy Weiss wrote:

> I haven't a clue if this is right, but if it were me, I'd try  
> something like this:
>
> 	    DELETE FROM T1 WHERE
> 	    (SELECT * FROM MyTable T1, MyTable T2
> 	    WHERE T1.dupField = T2.dupField
> 	    AND T1.dupField2 = T2.dupField2
> 	    AND T1.dupField3 = T2.dupField3
> 	    AND T1.uniqueField > T2.uniqueField)
>
> **use at your own risk. may delete every record in the table,
> burn your toast, and wreck your car. I assume no responsibility**

Jeremy -- Worked perfectly, thanks!

Kurt -- I went with Jeremy's because, frankly, I understand it. ;-)

Stephen

-- 
Stephen Rider
<http://striderweb.com/>