Adding an array in a SQL query

[leefish]

Thanks Techu - I'm gonna do a bit more work on it - adding totals and such - but its biggest flaw right now is that its not really shareable as its calling my field names for the upload file keys from Custom Thread Fields. I am struggling to replace the data in this piece of the query with something more generic

Code:

AND (a.field = 'fupload' OR a.field = 'fupload2' OR a.field = 'fupload3' OR a.field = 'fupload4')

---

Really it should be calling the upload mime but the "/"symbol in the rar and zip uploadmime types is beating me right now.