wordpress SQL删除某个分类下的所有文章

代码2022-05-16104 人已阅来源:网络

先检查下数据是否一致,将以下命令中的128替换成你准备删除文章所在分类的ID

SELECT * FROM wp_posts,wp_term_relationships WHERE wp_posts.ID = wp_term_relationships.object_id AND wp_term_relationships.term_taxonomy_id = 128

然后进行删除

DELETE wp_posts FROM wp_posts, wp_term_relationships WHERE wp_posts.ID = wp_term_relationships.object_id AND wp_term_relationships.term_taxonomy_id = 128