Delete all one-word comments

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:

  1. Resetting comment count
  2. Would switching to InnoDB from MyISAM improve performance of comments table?
  3. How to Delete Old Comments by Date?
  4. SQL query to delete comments older than 90 days?
  5. Recent comments from my blogs only
  6. Log file reports SQL Error processing child comments
  7. Control panel loads slowly due to 2 slow queries on comment table
  8. How do I comment out a block of tags in XML?
  9. How to log in to phpMyAdmin with WAMP, what is the username and password?
  10. Setting up foreign keys in phpMyAdmin?
  11. phpMyAdmin: secret passphrase?
  12. Forbidden :You don’t have permission to access /phpmyadmin on this server
  13. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)
  14. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  15. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  16. MySQL Error #1133 – Can’t find any matching row in the user table
  17. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  18. How to create a foreign key in phpmyadmin
  19. importing a CSV into phpmyadmin
  20. MySQL: Can’t create table (errno: 150)
  21. R: Comment out block of code
  22. MySQL: How to reset or change the MySQL root password?
  23. MySQL Daemon Failed to Start – centos 6
  24. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  25. Moving WordPress from MAMP to WAMP, can’t access pages
  26. Moving WordPress from MAMP to WAMP, can’t access pages
  27. Why do I get comment spam even with Akismet and Captcha?
  28. What tools are available for managing/writing to WordPress? [closed]
  29. How to rearrange fields in comment_form()
  30. setting comments off as default for pages and custom post types?
  31. Is it possible to pull comments from facebook into your blog?
  32. Filtering the Admin Comments List to Show Only Comments from the Current User?
  33. Non-threaded comment replies with link to original comment
  34. Approve comment hook?
  35. Commenting in user profile page?
  36. How to change “You must be logged in to post a comment.”
  37. comment_post_ID 0 (cannot remove from dashboard)
  38. Disable comments on all posts/pages
  39. How do I delete all comments from a specific old blog post?
  40. Removing the “Website” Field from Comments and Replies?
  41. Stop WordPress redirecting comment-page-1 to the post page?
  42. Importing old Disqus comments into WordPress
  43. How to add a class to the comment submit button?
  44. How to wrap submit button of comment form with div
  45. How to enable comments for pending and draft posts?
  46. Using WordPress’ WYSIWYG for comments
  47. Enable Submit Comment Without Page Reload (Using Ajax)?
  48. What for is the table “wp_commentmeta” exactly?
  49. Getting Post Comments for post ID using WP_Query() and a Custom Loop?
  50. Add option to disable comments on a per posts basis?
  51. When importing – failed to import: Invalid post type feedback
  52. How to change the email notification recipient (user) for new comments?
  53. Redirect user to a custom url after submitting the comment
  54. Paginate result set from $wpdb->get_results()
  55. Change Comment Author Display Name
  56. Custom comment type based on thread level
  57. How to add internal, revision comments to page updates
  58. How to load and show comments with AJAX instead of pagination?
  59. Linking to Page Showing Only Comments Without Parent Post
  60. Comment Reply javascript
  61. How do we remove the H3 tag for the reply-title I.D
  62. Comments not appearing at all
  63. comments reply script not working
  64. How to display comment form error messages in the same page
  65. 3 moderators to approve comment
  66. How to deal with small scale comment spam on small commercial sites? [closed]
  67. What should I do to make generated avatars different for anonymous comments?
  68. A plugin where users can comment with Facebook or Twitter or OpenID [closed]
  69. Check If comment author is registered
  70. Comments screen in backend, how to disable email address of commenter for non admins
  71. Add comments from the admin panel?
  72. How can I limit the number of comments per registered user per day?
  73. One comment per user per post but be able to reply to existing comments
  74. How to use a custom comments template
  75. Comment visibility
  76. What’s the easiest way to close comments on media/attachments?
  77. Reverse comment pagination numbers
  78. Get comments for more than one post
  79. How can I add comments to a page?
  80. How to remove comment spam in WordPress
  81. Post Comments using WP REST API v2 in WordPress
  82. show number of open comments on custom dashboard
  83. Show content only if member left a comment
  84. Add placeholder attribute to comment form fields
  85. Why do I get accidental comments without (the required) email address?
  86. How is comment spam received without a comments form?
  87. Does a reply to a wordpress comment notify the author of the comment?
  88. What are the current recommended best-practices for comments.php?
  89. human_time_diff() returns “48 years ago” for all comments
  90. How do I set up real anonymous posting in bbpress forums? [closed]
  91. Comment Count for each Comment Author
  92. Link name in comments to Author page? Comment Author Meta in Comments?
  93. How do I turn off wordpress comments ability to capture a users ip address?
  94. Showing comments only to same custom user role
  95. Parent comment’s author name
  96. Success message in comment form
  97. get_comments_number of depth-1 (Level 1) (1 post)
  98. Show comments from multiple post IDs in comment template
  99. Running a function on comment status change
  100. How to allow the reply link to remain on the comment form after I have reached my 10 nested comment limit?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)