正文:
先检查下数据是否一致,将以下命令中的 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
转载请注明:汇站网 » wordpress
SQL
删除某个分类下的所有文章