Delete them all. I don’t think a few comments are worth so much of your time.
To clean up the entire table, open a SQL console (the plugin Adminer has an UI for that) and type:
TRUNCATE table wp_comments
You might have to change the name if you are using an other prefix than wp_.
Or … you could use an existing anit-spam plugin with open source (Antispam Bee and/or T5 Spam Block for example) and run all your comments through their filters. In a secound round, find all IP addresses marked as spam already and delete all comments with matching IP addresses.
That should cover most of the spam.
Related Posts:
- Add option to disable comments on a per posts basis?
- comments reply script not working
- What should I do to make generated avatars different for anonymous comments?
- Check If comment author is registered
- How do I set up real anonymous posting in bbpress forums? [closed]
- How do I turn off wordpress comments ability to capture a users ip address?
- Success message in comment form
- How to allow the reply link to remain on the comment form after I have reached my 10 nested comment limit?
- Is there a hook for comment author link?
- How can I edit the email sent when a new comment is received?
- Exclude internal links from comment moderation?
- Change the HTML output of comments
- How to Block Access to Standard Login Flow and Comment Flow
- Upload images with comment
- Prevent Contributor to show comment list
- where to modify get_comment_author_link()?
- Change language of comments template
- Why Allow Script Commands in Comments?
- How to enable comments options?
- WordPress comment count to include attachment comments
- How to no follow the paginated comments
- Remove “Comments are closed” Notice from Custom Post Type template
- Displaying comments with a walker: how to distinguish between parent and child comments
- Comment count wrong with orphaned comments
- Comment form problem with comment_author_url and HTML5 input placeholders
- How would I count the number of times a comment meta field’s value is in a post’s entire comments?
- Pings and replies
- stackexchange-like submit comment window
- Comment_Reply_Link Not Showing?
- Display recent comments with gravatar and excerpts?
- Cannot get local avatars to show [closed]
- Limit user to one comment
- Sync comment data
- WordPress Comments are automatically publishing
- Comment displaying full name even after setting another display name?
- How to move comments box above comments
- save_post action hook for comments
- Ability to leave comments broken
- How to disable comment flood temporarily in a single scope
- How to create a seperate commenting system?
- How to handle upvotes and downvotes of disqus comments after importing disqus comments to wordpress?
- Change how many approved comments must user have
- Only admin can see comments on post or page
- Show comments of a user post only when they are login
- Display Custom comments field number
- How to get and use the the number of days since the last comment?
- Trying to post a wordpress comment on my site redirects to 127.0.0.1
- How do I add class to an admin comment?
- Best way to tell if a comment is from a user?
- How can get comment link by comment id?
- How to amend time format of comments, using child-theme?
- Make user’s name display as the site name in comments if it matches certain roles
- Display avatar with comment form?
- Adding SQL source code to comments
- How to control size of comments popup window?
- How to make comments private for commentor and post author
- Name of comment field differs on different sites
- WordPress Spam Comment Filter
- Which hook do I use to edit pending comment count on wordpress dashboard?
- Sent comments notifications to multiple users
- comment button shows only logged in users wordpress
- Applying same style to all the comments on the page
- Customise Comment form
- assumed as comment line
- stumped on add_action hook to delete_comment – any ideas?
- Avoiding calls to theme-compat
- Allow tags between shortcode in comments
- Return count for characters in the comment and perform action based on the length
- How to load new posts from wordpress db into wordpress homepage without refreshing the site?
- Delete/Spam Comment Button
- Who approved a comment, to show up in dashboard
- comments.php remove date/time’s #hyperlink
- comment just attachment .. reply just text … can I do that?
- How to make email field not required in comments?
- I have an odd field with a purple background, mentioning HTML-codes to use while leaving comments
- No comment Section but still got a Comment
- How to prevent users/authors from seing IP/email of new commentators?
- Why are my threaded comments not quite working? [closed]
- $post->comment_status always returns ‘closed’
- Order comments in admin by custom date
- edit comments in front end
- How to replace anonymous comment form with a registration form on wordpress?
- Comment moderation
- I have tried using Plugins to remove 72K comments with no success
- How to get the 5 most recent comments and each comment 5 most recent replies (children)
- Redirect first time comments
- Posting XML in comment section
- comment files and s
- Comments – Ensure the correct field is highlighted for nested replies
- Disqus moderation page not working in WordPress admin section
- How to hold all comments for moderation, including author’s comments on own post
- Comment forum to display under the comment you’re replying too
- Recent comments per tagged post?
- Subscribe to a post’s comments without posting a comment yourself
- WordPress error when sending comment
- How to hide the login / profile urls on top of comment box for a post
- wp_list_comments adds unnecessary elements
- Why default comment fields don’t show up?
- How can I filter the user avatar displayed in comments? – get_avatar_url filter works everywhere but not in comments
- WordPress Editor widgets “comments” and “post comments form” getting disappeared with elementor [closed]