Mass removal of comments possible?

[polaatx]

My site has been victim of spammers: http://lotteryofbirth.com/thumbnails.php?album=lastcom&cat=-8 with many ugly links. I finally figured out how to turn off anonymous comments. But now removing all this crap will take forever. Is there a way to remove all comments quickly? Or at least, is there a way to get it not to ask for comments-delete confirmation?

[Sami]

You can maualy delete them by phpmyadmin :
- open up the xxx_comments table from database
- here you can delete each of them or you could delete all the comments (both bad and good one) by running this query

Code Select Expand


truncate table xxx_comments

xxx_ is your  table pre fix
Once again , this query will delete all comments from the table be carefull

[Nibbler]

To delete any comments containing links:

Code Select Expand

DELETE FROM xxx_comments WHERE msg_body LIKE '%http%'

Backup the table before you run any queries if your comments are important.