Cleanup Duplicate Meta gives you a tool to check for and delete duplicate Post and/or User Meta entries in the database tables.

Tonya Mork

WPDC

There are times when your database gets filled up with duplicate entries that you may not want. Cleanup Duplicate Meta allows you to check for any duplicates in either the Post Meta or User Meta tables. Then if you want to get rid of them, simply click on the Cleanup button and Cleanup Duplicate Meta deletes the duplicates leaving either the first or last meta (you select which).
The interface is simple and easy to use:
<ol>
<li>‘Check for Duplicates’ queries the database and then displays all the duplicates found.</li>
<li>‘Count Duplicates’ counts all the duplicates found in the database (i.e. a total count).</li>
<li>The ‘Cleanup’ buttons trigger a SQL query to run, which deletes each of the duplicate entries, leaving either the first or last one (per your selection) in the database. All non-duplicates remain untouched by the plugin.</li>
</ol>
See the <a href="https://wordpress.org/extend/plugins/cleanup-duplicate-meta/screenshots/" rel="ugc">screenshots tab</a> for more details.

Cleanup Duplicate Meta

I was just about to write up my own plugin as a soltuion to clearing duplicates when I can across this plugin.
Cleanup Duplicate Meta is an awesome plugin that just saved me a good deal of time. Within a few minutes of installing the plugin I had successfully purged around 3,200 duplicate entries from a clients database (after taking a backup ;]).
Thanks for putting this plugin up in the repo for others to take advantage of!
Evan



Great Plugin

This plugin is perfect when working with a client database that has not been maintained properly. Goodbye duplicates. Thank you!



Easy to Use and Helpful

Cleaned up nearly 70,000 redundant _postmeta records with just a couple of clicks. Top marks.

Alternatives to Cleanup Duplicate Meta

Top alternatives