Skip to content

Instantly share code, notes, and snippets.

@john-hix

john-hix/duplicate-post-titles.sql

Created March 23, 2020 23:02
Show Gist options
  • Save john-hix/a95952b62c5d8f267573cab41c2c0e70 to your computer and use it in GitHub Desktop.
Save john-hix/a95952b62c5d8f267573cab41c2c0e70 to your computer and use it in GitHub Desktop.
Download ZIP
Find WordPress posts with duplicate titles
Raw
duplicate-post-titles.sql
SELECT wp_posts.post_title, COUNT(wp_posts.post_title) FROM wp_posts
GROUP BY wp_posts.post_title
HAVING COUNT(wp_posts.post_title) > 1
ORDER BY COUNT(wp_posts.post_title) DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment