16
Apr 2011
How to delete all comments in the wordpress
Posted in Miscellaneous by sibu at 8:14 pm |
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.
You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.