Delete All WordPress Comments at Once

This SQL query can delete all WP comments at once:

DELETE FROM wp_comments;

Alternatively you can delete only unapproved comments:

DELETE FROM wp_comments WHERE comment_approved = '0';

Alternatively you can delete only approved comments:

DELETE FROM wp_comments WHERE comment_approved = '1';

Alternatively you can delete only spam comments:

DELETE FROM wp_comments WHERE comment_approved = 'spam';

More Related Posts