WordPress MySql Statement To Delete All Pending Comments

February 6, 2023 by Rahul Sahu

To delete all pending comments in a WordPress database, you can run the following SQL statement using a database management tool like phpMyAdmin:

DELETE FROM wp_comments WHERE comment_approved = '0';

Note: Replace “wp_” with your WordPress database table prefix if it is different.