LinuxHelps.com

A blog for Linux Lovers.

Posted by sibu on April 16, 2011

How to delete all comments in the wordpress

To Delete All Comments Awaiting Moderation in WordPress:

(Make sure that you have tacken a db backup)

From phpmyadmin  select your WordPress database, click the sql tab, and enter the following query:

SELECT *FROM wp_comments WHERE comment_approved ="0"

That will select all the un-moderated comments. Then enter this query:

delete from wp_comments WHERE comment_approved ="0"

Run a check and repair on the WordPress database afterwards to be sure everything is working fine.

Add A Comment