wordpress 删除重复标题 sql

wordpress 删除重复标题 sql

如果您想通过SQL删除具有重复标题的WordPress文章,可以使用以下SQL查询。在执行查询之前,请确保备份您的WordPress数据库,以防止意外丢失数据。

请登录到您的数据库管理工具(如phpMyAdmin),然后执行以下SQL查询:

DELETE wp_posts
FROM wp_posts
INNER JOIN (
   SELECT post_title, MIN(id) as min_id
   FROM wp_posts
   WHERE post_type = 'post'
   AND post_status = 'publish'
   GROUP BY post_title
   HAVING COUNT(*) > 1
) as duplicates ON duplicates.post_title = wp_posts.post_title
WHERE wp_posts.post_type = 'post'
AND wp_posts.post_status = 'publish'
AND wp_posts.id > duplicates.min_id;

这个查询将删除具有相同标题的所有重复文章,但会保留每个重复组中ID最小的文章。如果您的WordPress表前缀不是wp_,请将查询中的wp_posts替换为您实际的表前缀。

未审核状态,去重

DELETE wp_posts
FROM wp_posts
INNER JOIN (
   SELECT post_title, MIN(id) as min_id
   FROM wp_posts
   WHERE post_type = 'post'
   AND post_status = 'pending'
   GROUP BY post_title
   HAVING COUNT(*) > 1
) as duplicates ON duplicates.post_title = wp_posts.post_title
WHERE wp_posts.post_type = 'post'
AND wp_posts.post_status = 'pending'
AND wp_posts.id > duplicates.min_id;
© 版权声明
THE END
喜欢就支持一下吧
点赞11 分享