wordpress批量删除指定分类所有文章

文章数量不多，可以直接后台手动删除，如果数量很多，需要执行SQL：

delete
from
wp_posts
using
wp_posts,
wp_term_relationships,
wp_term_taxonomy
where
wp_posts.id = wp_term_relationships.object_id
and
wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id
and
wp_term_relationships.term_taxonomy_id = 18（分类ID）

如果还需删除分类：

delete FROM `wp_term_relationships` where term_taxonomy_id = 18（分类ID）

如果需要删除指定post_type所有文章，执行：

DELETE FROM wp_posts WHERE post_type='post_type';
DELETE FROM wp_postmeta WHERE post_id NOT IN (SELECT id FROM wp_posts);
DELETE FROM wp_term_relationships WHERE object_id NOT IN (SELECT id FROM wp_posts)

另外，update更新内容的用法：

UPDATE wp_posts SET post_content = replace( post_content, '原内容','新内容') WHERE option_name = 'home' OR option_name ='siteurl';