There are several ways to remove all spam comments on a WordPress website in one go:
- Use a plugin: There are several plugins available for WordPress, such as Akismet, that can automatically detect and remove spam comments.
- Use the bulk edit feature: From the comments section in the WordPress dashboard, select all the spam comments and choose “Move to Trash” from the bulk actions dropdown.
- Use a SQL query: If you have access to your website’s database, you can use a SQL query to delete all spam comments in one go. You can use the following query:
DELETE FROM wp_comments WHERE comment_approved = ‘spam’;
Be sure to backup your database before making any changes, especially if you are not familiar with SQL.