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