If you do: Select concat(Fee,'some_dilimiter',Fie,'some_dilimiter',Foe), count(*) as wibble, Fee,Fie,Foe >From TableFoo Group by 1 order by 2 desc;
If you want to do a "having wibble > 1" then that'll eliminate all non-duplicates from the results. You should get a nice list of duplicates ordered by how many dupes there are.. Cheers, A -----Original Message----- From: Jeff McKeon [mailto:[EMAIL PROTECTED] Sent: Monday 08 December 2003 14:20 To: [EMAIL PROTECTED] Subject: Find duplicates query I'm trying to search a table for duplicate entries. A record is a dup if fields Fee, Fie, Foe are equal in two records. Would this query be correct to search the table for duplicates? Select Fee,Fie,Foe >From TableFoo Group by Fee,Fie,Foe Having Count(*) > 1; Thanks, Jeff -- 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]
