Cleaning up Anchor spam comments

I have Captcha set up for comments on this blog but stuff can still get through. While Anchor became defunct in 2020 maybe there's someone else out there still using it who would benefit from this (and I know my future self certainly will).

One thing that I found helpful was to turn off comments on a few posts. Nearly every bot comment was on Rigging PollDaddy and disabling additional comments heavily dropped volume. Then in site metadata I added spam keywords for Cyrillic and links. Prior to doing this I had ~8k spam messages in Cyrillic.

cheapnfl,Д,л,ж,н,п,т,и,г,т,ь,https://,http://

You can delete all comments with Cyrillic with this:

DELETE FROM
  anchor.anchor_comments
WHERE HEX(text) REGEXP '^(..)*D[0-4]' and status != 'approved';

You can also delete links with the following

DELETE FROM
  anchor.anchor_comments
WHERE
  (text LIKE '%https://%' OR text LIKE '%http://%')
  AND status != 'approved'