Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@man-oi

man-oi/Delete Duplicate Posts in Wordpress

Created May 17, 2018 06:45
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save man-oi/7bb1dd3c6f63b4c5034fe523a6a179d6 to your computer and use it in GitHub Desktop.
Save man-oi/7bb1dd3c6f63b4c5034fe523a6a179d6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Delete Duplicate Posts in Wordpress
DELETE bad_rows.* from wp_posts as bad_rows inner join ( select post_title, MIN(id) as min_id from wp_posts group by post_title having count(*) > 1 ) as good_rows on good_rows.post_title = bad_rows.post_title and good_rows.min_id <> bad_rows.id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment