Run the below query if you wish to bulk delete all the pending comments in wordpress. To run the query select SQL, paste the query and click GO.
DELETE from wp_comments WHERE comment_approved = '0'
Run the following query if you wish to bulk delete all approved comments in wordpress
DELETE from wp_comments WHERE comment_approved = '1'
Run the following query if you wish to bulk delete all spam comments in wordpress
DELETE from wp_comments WHERE comment_approved = 'spam'
Run the below query if you wish to bulk delete all the trash comments in wordpress
DELETE from wp_comments WHERE comment_approved = 'trash'Revisions
- March 15, 2015 @ 12:48:05 [Current Revision] by PeterLugg
- March 15, 2015 @ 12:48:05 by PeterLugg
Revision Differences
There are no differences between the March 15, 2015 @ 12:48:05 revision and the current revision. (Maybe only post meta information was changed.)
No comments yet.