Title: Remove duplicates?
Last modified: August 22, 2016

---

# Remove duplicates?

 *  [spinfly](https://wordpress.org/support/users/spinfly/)
 * (@spinfly)
 * [11 years, 4 months ago](https://wordpress.org/support/topic/remove-duplicates-1/)
 * I’ve imported a few different lists of redirects and now have several hundred
   of them.
 * I see duplicate redirects in this list, and I wish there was an easy way to remove
   all of them automatically.
 * [https://wordpress.org/plugins/redirection/](https://wordpress.org/plugins/redirection/)

Viewing 1 replies (of 1 total)

 *  Thread Starter [spinfly](https://wordpress.org/support/users/spinfly/)
 * (@spinfly)
 * [11 years, 4 months ago](https://wordpress.org/support/topic/remove-duplicates-1/#post-5736216)
 * FYI, this query on the DB will remove duplicates (rules defined first will be
   removed, rules defined later that are presumably more up-to-date will remain):
 * DELETE
    `n1` FROM `wp_redirection_items` `n1`, `wp_redirection_items` `n2` WHERE`
   n1`.`id` < `n2`.`id` AND `n1`.`url` = `n2`.`url`

Viewing 1 replies (of 1 total)

The topic ‘Remove duplicates?’ is closed to new replies.

 * ![](https://ps.w.org/redirection/assets/icon-256x256.jpg?rev=983639)
 * [Redirection](https://wordpress.org/plugins/redirection/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/redirection/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/redirection/)
 * [Active Topics](https://wordpress.org/support/plugin/redirection/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/redirection/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/redirection/reviews/)

 * 1 reply
 * 1 participant
 * Last reply from: [spinfly](https://wordpress.org/support/users/spinfly/)
 * Last activity: [11 years, 4 months ago](https://wordpress.org/support/topic/remove-duplicates-1/#post-5736216)
 * Status: not resolved