Check for duplicates in the same table

Posted 2 years ago by eriktobben

Hi!

I have a table containing 7 000 accounts with an email address and I want to check if any of these records are duplicates (email). What is the easiest way of doing that? Is it to fetch all records and run a foreach to the DB?

Please sign in or create an account to participate in this conversation.