LinuxHelps.com

A blog for Linux Lovers.

Archive for April, 2011

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.