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



6 komentar:

indometalgoth said...

wah...nice kang... :)

Budi said...

siipppp

yanmaneee said...

curry 6 shoes
hermes birkin
yeezy shoes
pandora jewelry
hermes
golden goose
supreme clothing
yeezy shoes
kawhi leonard shoes
yeezy

Unknown said...

weblink check out this site go to these guys Home Page visit our website read what he said

Unknown said...

web internet you could try here click for source Visit Website take a look at the site here

tewethot said...

s9y02g0v19 b8z02f4j48 c5r66y2l24 a4l27j2g02 s5m58z8n18 y4j86b0u31

Post a Comment

Please leave a comment here
Comment spam and other promotions will be deleted