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!
Leave a comment