mysql - 通过 mySQL 列出所有重复的帖子

Question

如何列出 wp_posts 中具有相同 post_title 的所有帖子？

Answer 1

考虑到 BrokenCrust 的评论

Assuming that wp_posts is from WordPress, it may also contain post revisions and pages or menus (and now custom types) that have the same post_title but that are not duplicate posts.

SELECT p1.* FROM wp_post p1 
INNER JOIN wp_post p2 ON (p1.id <> p2.id 
                      AND p1.post_title = p2.post_title
                      AND p1.revisions = p2.revisions
                      AND p1.page = p2.page)

如果您不想在列表中看到重复

SELECT DISTINCT p1.post_title FROM wp_post p1 
INNER JOIN wp_post p2 ON (p1.id <> p2.id AND p1.post_title = p2.post_title)