Sample Data: ID-Row1-Row2
1-A-B 2-A-B Row1 and Row2 are duplicate, so you only want one. Which ID do you want? -will On 4/17/06, Patrick Aljord <[EMAIL PROTECTED]> wrote: > > hey all, > I have a table "mytable" that looks like this: > id tinyint primary key auto_increment > row1 varchar 150 > row2 varchar 150 > > I would like to remove all duplicates, which means that if n records > have the same row1 and row2, keep only one record and remove the > duplicates. Any idea how to do this? > > thanks in advance > > Pat > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >