Remove Flamingo Spam messages Contact Form 7 WordPress (using SQL)
Okay so this one is something I can see a lot of people are looking for.

So Flamingo is great, it stores your contact form 7 messages and is a great tool if your client seems to be telling you the forms aren’t working, even though you know they are. Also, it’s just a handy tool to have as a safety measure. Either way, if you are reading this you know what it is so I’ll crack on.

Ok this morning I opened up a client’s site and she had 7,800 spam messages in Flamingo. I wasn’t going to sit there deleting them manually.

So if you can get to the database for the site, go to the ‘wp_posts’ table (mine is named sp_posts but if you have a standard install yours will be wp_posts).

Run an SQL to query all the ‘flamino_spam’ entries under ‘post_status’, or just go to ‘Search’ and scroll down to ‘post_status’ and type in ‘flamingo_spam’ and hit go. This should bring up all the spam.

Then finally run this command to kill them with hot fire –

DELETE FROM wp_posts WHERE post_status LIKE ‘flamingo_spam’

Hot diggidy, no more spam. Have you ever actually eaten spam? It’s not great.