wordpress SQL删除某个分类下的所有文章
先检查下数据是否一致,将以下命令中的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