要选择需要删除的所有术语ID，请执行以下操作：

select wp_terms.term_id from wp_terms
left join wp_term_taxonomy on wp_terms.term_id = wp_term_taxonomy.term_id
where wp_terms.term_id in (
    select term_taxonomy_id from wp_term_relationships where object_id in (
        select object_id from wp_term_relationships where term_taxonomy_id = 705
    )
)
and wp_term_taxonomy.taxonomy = \'post_tag\'

基本上，首先我获取类别ID为705的所有帖子ID（从wp\\U term\\u relationships中选择object\\u ID，其中term\\u taxonomy\\u ID=705），然后我使用这些ID获取添加到wp\\U term\\u relationships表中这些帖子的所有术语ID（从wp\\U term\\u relationships中选择term\\u taxonomy\\u ID…）最后，我通过只过滤那些标记的ID（和wp\\u term\\u taxonomy.taxonomy=\'post\\u tag\'），从wp\\u terms获得所有重要的ID。

获得所有这些ID后，可以使用它们通过SQL查询进行删除，如the_dramatist answer, 或者您可以使用Wordpress函数，以便WP能够处理拥有干净数据库所需的一切：

<?php
$ids = array(12, 23, 45, 100);
foreach($ids as $id) {
    wp_delete_term( $id, \'post_tag\' );
}
?>

好吧，考虑将任务分成多个部分。首先，我们需要获取帖子id，其中包含id为705的类别，然后我们将从这些帖子中删除标签。

现在，如果我们将这个想法转化为SQL，那么查询将是-

DELETE wp_term_relationships FROM wp_term_relationships
INNER JOIN wp_term_taxonomy ON ( wp_term_taxonomy.term_taxonomy_id = wp_term_relationships.term_taxonomy_id )
WHERE wp_term_taxonomy.taxonomy = \'post_tag\' AND wp_term_relationships.object_id IN (SELECT id
FROM (SELECT wp_posts.id FROM wp_posts
       INNER JOIN wp_term_relationships
               ON wp_term_relationships.object_id = wp_posts.id
       INNER JOIN wp_term_taxonomy
               ON wp_term_taxonomy.term_taxonomy_id = wp_term_relationships.term_taxonomy_id
       INNER JOIN wp_terms
               ON wp_term_taxonomy.term_id = wp_terms.term_id
WHERE wp_terms.term_id = 705 AND wp_term_taxonomy.taxonomy = \'category\' ) AS posts)

希望这有帮助。