WordPress不支持逐帖批量管理评论。尽管它在帖子的编辑页面上有一个评论管理部分。正如你所说，你必须在每条评论上点击“垃圾”：

或者，您可以备份wp\\U comments和wp\\U commentmeta表，并运行以下查询：

查找帖子ID。假设相关ID为X。

SELECT ID from wp_posts WHERE post_type=\'post\' AND post_title=\'Hello world!\' INTO @x; 

INSERT INTO wp_commentmeta (comment_id, meta_key, meta_value) SELECT comment_ID, "wp_trash_meta_time", UNIX_TIMESTAMP() FROM wp_comments WHERE comment_post_ID=@x;

INSERT INTO wp_commentmeta (comment_id, meta_key, meta_value) SELECT comment_ID, "wp_trash_meta_status",comment_approved FROM wp_comments WHERE comment_post_ID=@x;

UPDATE wp_comments SET comment_approved=\'trash\' WHERE comment_post_ID=@x;

你好@Jeff Atwood:

我假设您具有MySQL查询访问权限。这将为URL slug为的博客文章提供所有评论\'your-blog-post\' （如果您使用的是永久链接，那么slug是您帖子URL中的最后一段，即http://example.com/2011/01/foo-bar-baz/ 你的子弹会是\'foo-bar-baz\'):

SELECT * from wp_comments WHERE comment_post_ID IN (
  SELECT ID FROM wp_posts WHERE post_name=\'your-post-slug\'
)

SELECT * from wp_commentmeta WHERE comment_id IN (
  SELECT comment_ID from wp_comments WHERE comment_post_ID IN (
    SELECT ID FROM wp_posts WHERE post_name=\'your-post-slug\'
  )
) 

DELETE from wp_commentmeta WHERE comment_id IN (
  SELECT comment_ID from wp_comments WHERE comment_post_ID IN (
    SELECT ID FROM wp_posts WHERE post_name=\'your-post-slug\'
  )
);

DELETE from wp_comments WHERE comment_post_ID IN (
  SELECT ID FROM wp_posts WHERE post_name=\'your-post-slug\'
);

我不建议直接从数据库中删除，因为数据可能有依赖关系，最终可能会导致孤立记录。

使用post ID（将其添加到ADDPOSTID), 保存下面的脚本并将PHP文件添加到WordPress网站的根目录中，以管理员身份登录并直接在浏览器上调用该文件：

<?php

require(\'./wp-load.php\');

if ( current_user_can( \'manage_options\' ) ) {
    if ( $comments = get_comments( array( \'post_id\' => ADDPOSTID ) ) ) {
        foreach ( $comments as $comment ) {
            echo \'<p>Deleting comment \'.$comment->comment_ID.\'</p>\';
            wp_delete_comment( $comment->comment_ID, true );
        }
    } else {
        echo \'<p>No comments found</p>\';
    }
} else {
    echo \'<p>Not allowed</p>\';
}

如今，最好的解决方案if 您可以安装WP-CLI 在服务器上，将以这种方式使用它：

$ wp comment delete $(wp comment list --post_id={ID})

这还不够，还必须更新列计数，否则将无法正确显示。以下是多站点安装的示例代码。

try 
{   
    $rowsUpdated = $wpdb->query(
    "
    UPDATE " . $wpdb->prefix . "COMMENTS SET COMMENT_APPROVED=\'trash\' 
    WHERE comment_post_id = " . $post_id
    );
    if ( $rowsUpdated != 0 ) {
        $wpdb->query( 
            "
            UPDATE " . $wpdb->prefix . "POSTS SET COMMENT_COUNT = COMMENT_COUNT - " .  $rowsUpdated . "
            WHERE ID = " . $post_id
        );
    }
}       
catch (Exception $e) 
{ 
    echo( \'Unexpected error while trying to connect to WP database: \' . $e->getMessage() );
}