I had 680 spam comments on my blog referencing the site ‘freehostia’. I used this SQL command to clear it our:
UPDATE `comment_approved` FROM `wp_comments` WHERE `comment_author_url` LIKE ‘%freehostia&’;
Phew. Feels nice to have a nice, clean blog. Now comment away!