DISCLAIMER : Not a WordPress Developer, Just a MySQL DBA
If you have privileges to login to MySQL and query data you could collect all the comment_ID values that have one word.
SELECT comment_ID FROM wp_comments WHERE
REPLACE(TRIM(comment_content),' ','')=TRIM(comment_content);
You can test this by also seeing the comment_content
SELECT comment_ID,comment_content FROM wp_comments WHERE
REPLACE(TRIM(comment_content),' ','')=TRIM(comment_content);
Using the WordPress API, retrieve those comment_ID values and delete them.
Give it a Try !!!
CAVEAT
Other posts have been given for bulk deleting of comments (none of these are my posts):
Related Posts:
- Resetting comment count
- Would switching to InnoDB from MyISAM improve performance of comments table?
- How to Delete Old Comments by Date?
- SQL query to delete comments older than 90 days?
- Recent comments from my blogs only
- Log file reports SQL Error processing child comments
- Control panel loads slowly due to 2 slow queries on comment table
- Disable comments on all posts/pages
- Stop WordPress redirecting comment-page-1 to the post page?
- Importing old Disqus comments into WordPress
- How to add a class to the comment submit button?
- Linking to Page Showing Only Comments Without Parent Post
- Post Comments using WP REST API v2 in WordPress
- Show content only if member left a comment
- Using filter to add additional fields to comment_form()
- Disable wordpress comments API
- List Recent Comments from Across a Multi-site Network
- Comments waiting but no comments found
- Programmatically block commenting by restricting view of comment form
- Disqus over the default commenting engine, what are some pros and cons?
- Comments screen in backend, how to disable Quick Edit | Edit | History | Spam | for non admins
- How To Remove The “Click here to cancel reply” Link From The WordPress Comment Form
- Plugin from WordPress.com for comment notification…available? [closed]
- How to add text to comment form #content textarea?
- Get most active users sort by comment count
- Passing arguments to wp_list_comments callback function
- What are the additional fields in wp_comments used for?
- comments_template not working correcly in custom template files
- Why are my comments closed?
- Block comments from search engine indexing
- Create a “Reject” action for comments?
- How to change style of Disqus comment count on main page
- Adding another arg to comments_popup_link
- Exclude Duplicate Posts in this SELECT Query
- List User Comments on User Profile BuddyPress [closed]
- Changing “submitted on date” of comments
- Filter custom comment type from Manage Comments & Dash Widgets
- How to allow more HTML tags in comment for a certain comment_type
- How to deal with spam comments and distinguish them from non-spam comments?
- How to add a strip of visual editor on top of comments textarea
- Threaded comments not working
- Customizing comments pagination for bootstrap
- Same email for all comments
- Comment Form – E-mail Not Required!
- Get a total count for all comments and display result
- Notification if Comment Author Field is left empty. E.g. change input border colour
- List comments received by every posts of an specific author
- How do I reply to comments from admin panel on a tablet PC?
- Disable comments for a user? [closed]
- Polls with respective comments?
- Filtering the Admin Comments List to Show Only Comments from the Current User?
- Ajax submit comments
- How do I automatically insert some text in the comment textbox on submit?
- I cannot view the comments
- Can’t update WordFence Options, clear data manually
- In wp_list_comments comment dates won’t work?
- Where are comment ratings stored?
- Setting up WordPress Locally on WAMP for a new site (with one already)
- how to SELECT for the current post id?
- Replying to comments
- Custom comment link
- How to display the user’s comment status on the front end
- get_comments_number() vs. get_post_field( ‘comment_count’, ID )
- unsetting required fields in the comment reply form
- Problem code and show comments
- Comments turned off, but ‘Leave a reply’ link still there [duplicate]
- How to output number of comments with link to comments
- Highlight comments made by registered users of the site
- How do I make Twenty Ten display comments on the home page?
- It doesn’t matter if I have more than one comment. get_comments_number still equal to one?
- Simple spam check for valid domain in commenter’s email address
- Allowing WordPress.org/com accounts on a self-hosted install
- How to remove the “comments” bit that appears next to or below the posts
- Sort post comments from newest to oldest in pagination
- Post comments don’t show
- Update post “A” on comment submition on post “B”
- SQL query to change custom field in WordPress database
- Using Disqus with headless WordPress setup?
- Attaching author tag to the comment
- Pre- Approved Comment Capability
- Delete comments function
- Comment form not working
- How to show a “Comments Are Closed” message on posts where comments have been closed?
- Comments pagination on author page
- Comments page id wp_list_comments
- spacebar is not working in input and textarea
- wp-editor-area textarea disapear on cancel-comment-reply-link click
- Conditionally process comments while ignoring replies
- Required Field for Comment parent only?
- Can I use WP comments for custom tables?
- How can I have a full comments.php for an easy editing of all its aspects?
- Transfer comments from one domain to another
- writing a plugin, how to disable the comment form altogether?
- What filter or action to replace comments or add new comment system
- Function to get a list of all comments on 1 post [closed]
- Display DISQUS on homepage
- Auto delete WordPress comments
- How to disable comments on new blog post, but allow on new products?
- Query comments with non-empty ‘author_url’ value on Admin Comments Screen
- Customize the new comment notifications sent to the post author after the comment is approved