Search and Replace/Delete

[borbole]

You can delete all the posts made by the spammers with the following query:

DELETE FROM post WHERE userid = 'spammeruid';

And replace the spammeruid with the actual userid number of the spammer.

If the spmammer has been deleted and all their posts appear as guests, try this query instead:

DELETE FROM post WHERE username='spammerusername' ;

And replace the spammerusername with the ex username of the spammer.

Hope it helps.