How to remove posts without images mysql query?

Question

I run a few autoblogs on wordpress and sometimes the following problem occurs, while using FeedWordPress some syndicated posts don't contain images and I'd like to know if there is a query in mysql allowing removing posts without images?

Answer 1

having no clue of what your structure or data looks like, here's something that might help.
before deleting, select to make sure that these are posts that you want to delete

SELECT * FROM posts WHERE post_content NOT LIKE '%<img src=%'

then after seeing the results and you're happy to delete them, use

DELETE FROM posts WHERE post_content NOT LIKE '%<img src=%'