WordPress tip: Bulk delete comments with a specific url

Just run the following query on your WordPress database to delete comments with nastyspamurl as url. Don’t forget to replace the table prefix wp_ if your database is using another prefix.
And of course, create a backup of your database before running the query!

DELETE from wp_comments WHERE comment_author_url LIKE "%nastyspamurl%" ;