How To Delete Spam Comments?

You all must know by comment spam is not it? one problem is quite annoying for the blog owner is the comment spam that comes every day, to the owner of wordpress-based blog comment spam can be minimized by installing the Akismet plugin but still could not prevent comment spam to stop by to our blog.

Sometimes maybe so busy these spam comments deleted and eventually forget to continue to accumulate up to hundreds or even thousands of spam comments which eventually meet in the database space hosting overwhelmed us and make our own to delete them manually. What if there are 9000 comment spam? How much time do we need to remove them manually?

But do not be afraid because you can delete all comment spam is really quick and easy, here's how:

1. login to cpanel / hosting you and go into phpMyAdmin

2. Then click the SQL

3. Paste the following code in the box SQL:

DELETE from wp_comments WHERE comment_approved = '0 ';

Technical Explanation: In the table there are fields named wp_comments comment_approved, which has two values ie 1 and 0, where 1 is for comments that have been approved, while 0 is not yet approve.

So before deleting comment spam in this way, make sure first that you already had approved the comment is not spam. Because not all the comments that have not approve it is spam.

Note: This tip is for friends who use wordpress with hosting his own and with a database of "restricted". Do not do these tips if you do not understand

Related Post