Mass Delete Kayako 3 Comments

If you have more than 100 spam comments to delete, you might need to spend quite a fair bit of time to delete. Time is precious. Here is a quick way to mass delete all the comments.

DELETE swcomments, swcommentdata FROM swcomments, swcommentdata WHERE swcomments.commentid = swcommentdata.commentdataid AND swcomments.isapproved = '0';

I am not responsible for any damage caused in your system, please DO backup before you execute any SQL query.

Hope this helps!