Bulk delete comments with a specific url

DELETE from wp_comments WHERE comment_author_url LIKE "%nastyspamurl%" ;
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.

1 Response

Might be worthwhile pointing out in the title that this is related specifically to Wordpress tables, rather than as a general SQL thing.

Write a comment

You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.