Hello,
Let's say I have a MySQL database with the fields ID and EMAIL. ID being integer, auto_increment, primary key and EMAIL varchar. Is there any way I can check in PHP or MySQL which of the emails have duplicated records without changing the primary key to the EMAIL field?