Created
March 23, 2020 23:02
-
-
Save john-hix/a95952b62c5d8f267573cab41c2c0e70 to your computer and use it in GitHub Desktop.
Find WordPress posts with duplicate titles
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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