I'm trying to delete all wordpress comments with only one word. I found this mysql query to delete all comments at once, but that's not what I want to achieve:
DELETE FROM wp_comments WHERE comment_approved = '0'
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
You can test this by also seeing the comment_content
Using the WordPress API, retrieve those
Give it a Try !!!
Other posts have been given for bulk deleting of comments (none of these are my posts):