Lachlan, I want to identify the entries in the table where the email addresses are the same as another entry. Whatever else is in the record does not matter to me.
However, a second requirement for the query is that it show me the last duplicate instead of the first. This way I keep the first entries and remove subsequent ones. Thanks, Jonathan Duncan >>>"Lachlan Mulcahy" <[EMAIL PROTECTED]> 07/08 10:59 pm >>> Jonathan, I'm not exactly sure what you want to do.. Do you want to identify the entries in the table where the email addresses are the same as another entry but the name and address details differ... or.. do you want to find entries where the name and address information is the same but email addresses differ? Lachlan -----Original Message----- From: Jonathan Duncan [mailto:[EMAIL PROTECTED] Sent: Friday, 9 July 2004 7:54 AM To: [EMAIL PROTECTED] Subject: Weeding out duplicates I am trying to get rid of duplicate user info entries in a database. I am assuming that the email address is unique but other information, like first name, last name, address, etc are not. The "email" field is not a unique field in the database. I was trying something like the following, but not getting what I wanted. select distinct u1.id,u1.firstname,u1.lastname,u1.email from Users u1, Users u2 where u1.email=u2.email; How can I go about identifying the duplicate entries of email addresses? Thank you, Jonathan Duncan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]