DELETE FROM wp_posts WHERE post_status LIKE ‘flamingo_spam’

or to complete claer flamingo content

DELETE FROM wp_posts WHERE post_type LIKE ‘%flamingo%’