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