Hi A long hand way to do this is use count to find out how many times this happens. Then use limit to one less than count?
Hope this helps Simon -----Original Message----- From: Ville Mattila [mailto:[EMAIL PROTECTED]] Sent: 03 January 2002 15:03 To: [EMAIL PROTECTED] Subject: Removing duplicate entries Hello, I was wondering how would it be possible to delete those records from database which has just same data? There can be also up to ten copies of the record in database, and all but one should be deleted. Do you have any easy way to do this? Thank you, Ville Mattila --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php