If you know yourself around phpMyAdmin and MySQL queries, just run this one line query in the “Sql Query” window of your WordPress database in phpMyAdmin. This query instantaneously deletes all comments in “pending” status. All your approved comments won’t be touched. To be on the safer side you may also want to backup your entire database or just wp_comments table just in case something goes wrong.
1. Open your WordPress mysql database in phpMyAdmin.
2. Find out the name of your WordPress comments table (mostly it is “wp_comments”).
3. Click on the “SQL” tab at the top of the page.
4. Insert the following mysql command to the text box and click “Go”.
2. Find out the name of your WordPress comments table (mostly it is “wp_comments”).
3. Click on the “SQL” tab at the top of the page.
4. Insert the following mysql command to the text box and click “Go”.
DELETE FROM wp_comments WHERE comment_approved=0
No comments:
Post a Comment