Revision 420 is a pre-publication revision. (Viewing current revision instead.)

Batch delete WordPress comments with phpMyAdmin

All you need to know is that unapproved comments are marked with 0 and approved comments are marked with 1. Back up your db and then running the following query making sure you have the right table prefix for your db. DELETE from wp_comments WHERE comment_approved = '0'; or DELETE from wp_comments WHERE comment_approved = '1';

Revisions

  • April 21, 2013 @ 01:30:32 [Current Revision] by PeterLugg
  • April 21, 2013 @ 01:30:04 by PeterLugg

Revision Differences

April 21, 2013 @ 01:30:04Current Revision
Content
Unchanged: All you need to know is that unapproved comments are marked with 0 and approved comments are marked with 1.Unchanged: All you need to know is that unapproved comments are marked with 0 and approved comments are marked with 1.
Unchanged: Back up your db and then running the following query making sure you have the right table prefix for your db.Unchanged: Back up your db and then running the following query making sure you have the right table prefix for your db.
Deleted: <pre>DELETE from wp_comments WHERE comment_approved = '0';</pre> Added: DELETE from wp_comments WHERE comment_approved = '0';
 Added: or
 Added: DELETE from wp_comments WHERE comment_approved = '1';

Note: Spaces may be added to comparison text to allow better line wrapping.

No comments yet.

Leave a Reply