Find all posts and replies that have images inserted/attached

(Jane Jojo) #1

Related to:

Title says it all: Is it possible to list all posts and responses that have images associated with it?

(Jeff Atwood) #2

Hmm this is a good point @zogstrip do we have an advanced search operator for “post has at least one image”? That could be quite handy if it’s not nightmarishly difficult to implement.

(Jay Pfaffman) #3

I think that now you’d need the data Explorer plugin and search raw for upload://

Edit: But I wasn’t even close.

(Kane York) #4

I think the post_uploads table carries this relation.

(Régis Hanol) #6

Yup, we have “with:images” which is generic and “filetype:jpg” which looks for a specific upload extension.

(Jane Jojo) #7

Can I do a OR?

“with:images filetype:jpg OR filetype:jpeg”


You can join the file types with a comma to achieve an OR, i.e.

with:images filetype:jpg,jpeg

(system) #9

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.