How to Remove Thousands of Approved Spam Comments WordPress, here some way to remove spam coments on your wordpress platform. Now WordPress Engine has been updated on new version, there is a much simpler way to delete approved comments in bulk / Spam Comments.
1. Open Cpanel > Go to phpmyadmin
2. Choose database website from the left panel: like _wrdp1 for example.
3. Search wp_comments in the main page.
4. klik query and write code script above
delete from wp_comments WHERE comment_approved =”1″;
and now all you comments spam / bulk is gone. This will delete ALL approved comments – change wp_ to your actual database table prefix. before do this I suggest you to backup your database website first.