WordPress中删除垃圾评论的方法
<p style='margin: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; font-family: tahoma, arial, "Microsoft YaHei";'>对于日访问量还不错的WordPress网站来说，肯定都会存在很多待审核的垃圾评论，如果要通过WP后台删除，那简直是一件非常耗时又耗力的工程。今天，我们主要介绍以下两种方法来进行WordPress垃圾评论的删除.我们可以执行SQL命令批量删除，或者通过启用 Delete All Pending Comments插件来进行删除。</p>
<strong style='font-family: tahoma, arial, "Microsoft YaHei"; font-size: 14px;'>方法一：Delete All Pending Commnets插件删除</strong>
<p style='margin: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; font-family: tahoma, arial, "Microsoft YaHei";'>
后台搜索安装Delete All Pending Commnets插件以后，就可以在左边的评论菜单下看到一个 Pending Comments，进去后勾选复选框，然后点击 delete 按钮就可以删除所有待审核的评论了：</p>
<p style='margin: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; font-family: tahoma, arial, "Microsoft YaHei";'>
<img title="WordPress中删除垃圾评论的方法" alt="WordPress中删除垃圾评论的方法" src="https://zhuji.jb51.net/uploads/img/202305/4142aa0675d5a50b2ef6c5b047832a0d.jpg" style="max-width:100%!important;height:auto!important;border: 1px solid rgb(204, 204, 204); vertical-align: middle; padding: 1px; overflow: hidden; max-width: 696px; width: 600px; height: 216px;"></p>
<strong style='font-family: tahoma, arial, "Microsoft YaHei"; font-size: 14px;'>方法二：通过 SQL 命令删除</strong>
<p style='margin: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; font-family: tahoma, arial, "Microsoft YaHei";'>
如果你不喜欢折腾插件，并且你可以通过登陆PhpMyAdmin 管理MySQL数据库，那你可以通过 SQL 命令来删除<br>
Wordpress评论表为wo_comments，comment_approved为评论回应的字段.</p>
<span style='font-family: tahoma, arial, "Microsoft YaHei"; font-size: 14px;'>Comment_approved 为1 ：通过审核的评论Comment_approved 为0：待审核的评论Comment_approved 为trash：回收站的评论Comment_approved 为spam: 垃圾评论</span>
<p style='margin: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; font-family: tahoma, arial, "Microsoft YaHei";'>
详细SQL命令执行方法如下所示，可以根据需要随时更改该语句.</p>
<p style='margin: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; font-family: tahoma, arial, "Microsoft YaHei";'>
<img title="WordPress中删除垃圾评论的方法" alt="WordPress中删除垃圾评论的方法" src="https://zhuji.jb51.net/uploads/img/202305/c8e45417282599f3c99da98ce2101cf4.jpg" style="max-width:100%!important;height:auto!important;border: 1px solid rgb(204, 204, 204); vertical-align: middle; padding: 1px; overflow: hidden; max-width: 696px; width: 600px; height: 244px;"></p>
<p style='margin: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; font-family: tahoma, arial, "Microsoft YaHei";'>
</p>
<span style='font-family: tahoma, arial, "Microsoft YaHei"; font-size: 14px;'>1. 删除待审核评论，垃圾评论，回收站评论</span>
<p style='margin: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; font-family: tahoma, arial, "Microsoft YaHei";'>
delete<br>
From ‘wp_comments’<br>
WHERE ‘cooment_approved’ NOT LIKE ‘1’</p>
<span style='font-family: tahoma, arial, "Microsoft YaHei"; font-size: 14px;'>2. 只删除待审评论</span>
<p style='margin: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; font-family: tahoma, arial, "Microsoft YaHei";'>
delete<br>
From ‘wp_comments’<br>
WHERE ‘cooment_approved’ =‘0’</p>
<span style='font-family: tahoma, arial, "Microsoft YaHei"; font-size: 14px;'>3. 只删除垃圾评论</span>
<p style='margin: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; font-family: tahoma, arial, "Microsoft YaHei";'>
delete<br>
From ‘wp_comments’<br>
WHERE ‘cooment_approved’=’spam’</p>
<span style='font-family: tahoma, arial, "Microsoft YaHei"; font-size: 14px;'>4只删除回收站评论</span>
<p style='margin: 0px; padding: 5px 0px; outline: none; font-size: 14px; line-height: 30px; font-family: tahoma, arial, "Microsoft YaHei";'>
delete<br>
From ‘wp_comments’<br>
WHERE ‘cooment_approved’=’trash’</p>
頁:
[1]