WordPress Code Snippets

A fresh mix of code snippets and tutorials

Find duplicate email addresses in WordPress


This tutorial explains how to find duplicate email addresses in your WordPress database. That way you can delete or modify as needed.

In WordPress, users can not change their username, but they can change their email address all day long. This and other factors means that you may end up with multiple/duplicate addresses in your database. To find them, execute the following query (via phpMyAdmin or whatever works for you):

Note that you may need to edit the wp_ string to match any custom prefix that you are using for your database tables.

That query will return any/all duplicate email addresses, so you can deal with them however you like (e.g., change ’em, delete ’em, etc.).


SQL query for cleaning up any newline/return characters appended to email addresses:

Remember to always back up your database before making any changes :)

Learn more

WordPress Themes In Depth

Show Support

Like our new Facebook Page to show support!