SQL: Delete Comments With a Specific URL
DELETE from wp_comments WHERE comment_author_url LIKE "%nastyspamurl%" ;