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]