Skip to content

Instantly share code, notes, and snippets.

@dingo-d

dingo-d/duplicates.sql

Created November 20, 2017 14:37
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 dingo-d/0367aa1a26f685c8d0564b3ade497b55 to your computer and use it in GitHub Desktop.
Save dingo-d/0367aa1a26f685c8d0564b3ade497b55 to your computer and use it in GitHub Desktop.
Download ZIP
Find duplicates
Raw
duplicates.sql
SELECT post_title, COUNT(*) c FROM wp_posts WHERE post_type = 'post' GROUP BY post_title HAVING c > 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment