WordPress tip: Bulk delete comments with a specific url

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%" ;

The post WordPress tip: Bulk delete comments with a specific url appeared first on WPRecipes.

What’s My SEO Score?

Enter the URL of any landing page or blog article and see how optimized it is for one keyword or phrase.

Wordpress Expert
Rating

Leave a Reply