[snip] Is it possible to run a query that would return all rows that are exact duplicates except for the unique identifier? [/snip] Yes, it is possible. Start here.... SELECT COUNT(`foo`) AS `duplicate` FROM `bar` GROUP BY `foo` HAVING `duplicate` > 1