wordpress批量删除指定无用的垃圾标签

使用场景和用途

1.由于网站之前网站启用了Autotags插件，导致乱截取关键词什么a，b，c等等这种单个字母的文字用处不大还占用了tag标签地搜索引擎的影响。因为标签和文章绑定关系所以要多表联查删除。所以有了今天的教程。

查询分类下的文章信息

select ID
from wp_posts,wp_term_relationships,wp_term_taxonomy 
where ID=object_id 
and wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id 
and post_type="post" 
and post_status = "publish" 
and wp_term_relationships.term_taxonomy_id = 393
and taxonomy = "category"

查询指定标签的数量

SELECT *
FROM wp_terms AS a
LEFT JOIN wp_term_taxonomy AS c ON a.term_id = c.term_id
LEFT JOIN wp_term_relationships AS b ON b.term_taxonomy_id = c.term_taxonomy_id
WHERE c.taxonomy = 'post_tag' AND c.count = 0

删除指定标签的名称（查询条件按数量）

DELETE a,b,c
FROM wp_terms AS a
LEFT JOIN wp_term_taxonomy AS c ON a.term_id = c.term_id
LEFT JOIN wp_term_relationships AS b ON b.term_taxonomy_id = c.term_taxonomy_id
WHERE c.taxonomy = 'post_tag' AND c.count = 0

特殊说明：如果进行了以下操作可能会无法正常显示分页信息，即删除了分页和数量都在，其实已经都删除掉了

如果网站进行了这篇文章的更改会出现以上问题。点我前往>>>>文章源自玩技e族-https://www.playezu.com/175285.html

 文章源自玩技e族-https://www.playezu.com/175285.html 文章源自玩技e族-https://www.playezu.com/175285.html