I want to retrieve all spam comments in my Drupal DB to remove them using SQL DELETE statement.
I cannot find how comments are marked as spams in Drupal DB's comment table.
The only relevant column in comment table is status, which takes value 0 when the comment is unpublished.
But the unpublished comment can be either a legitimate comment (i.e. not yet approved), or a spam comment.

So, how to retrieve all spam comments by SQL to delete them from comments table ?


Check Solution