How bout.... Delete from tablename where email like [EMAIL PROTECTED] && ID <> 1
Jeff > -----Original Message----- > From: Karam Chand [mailto:[EMAIL PROTECTED] > Sent: Monday, July 28, 2003 10:33 AM > To: [EMAIL PROTECTED] > Subject: Deleting duplicating records > > > Greetings > > I manage a website wherein i keep track of the people > email who have downloaded my software and the version > number. > > the structure is like - > > id int auto_increment primary key, > email char, > version > > now the same person can download different version > therfore my table has data like this - > > 1,[EMAIL PROTECTED],1.0 > 2,[EMAIL PROTECTED],2.0 > 3,[EMAIL PROTECTED],3.0 > > Now I want to delete all the records wherein all rows > with duplicate email addresses are deleted so that i > have data like > > 1,[EMAIL PROTECTED],1.0 > ... > > What should be the query? Thanks in advance. > > Karam > > __________________________________ > Do you Yahoo!? > Yahoo! SiteBuilder - Free, easy-to-use web site design > software http://sitebuilder.yahoo.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]