How can I deduplicate?

Solutions for other advanced phplisters

How can I deduplicate?

Postby patrick24601 » 10:32pm, Tue 25 Dec, 2012

Is there a query that I can run to cleanup my database of duplicate email addresses? I've imported from another email solution, and I am sure that I have duplicates. Thanks.
Posts: 6
Joined: 9:52pm, Sun 27 Apr, 2008

Re: How can I deduplicate?

Postby Dragonrider » 10:07am, Wed 26 Dec, 2012

I think you'll find the Merge Duplicate Users option is what you want. Login to admin, then Manage Users and Reconcile Users, then Merge Dup.

Make a duplicate of your DB just in case first. :)
My sites:-,,,
Latest phpList version is now 3.0.12 (3 February 2015) and requires a minimum of MySQL 5.0 and PHP 5.3.x
Posts: 3460
Joined: 6:58am, Sun 02 Jul, 2006
Location: Ilkley, West Yorkshire, United Kingdom

Return to Advanced Answers, Howtos, Tips & Tricks

Who is online

Users browsing this forum: No registered users and 1 guest