Deleting Comment Spam

drush-delete-spam.md

delete obvious spammy subjects

drush sqlq "delete from comment where subject like '%viagra%'" drush sqlq "delete from comment where subject like '%payday loan%'"

or if you know the last good comment id, ie > 3002 and < 4005

first look at the list

drush sqlq "select name,subject from comment where cid > 3002 and cid < 4005"

next delete the spam

drush sqlq "delete from comment where cid > 3002 and cid < 4005"

If you are unfamiliar with the comment table, you can run desc table from commandline

drush sqlq "desc comment"