ANDing multiple values in a field

[ZiNgA BuRgA]

Your solution is probably the best there is.  I'm not sure if there's a nice way to toggle OR/AND, so I picked the most likely to be used, OR.
Filtering on multi-valued fields is quite ugly, so I didn't really want to put much effort into it.  It's there for completeness sake, but the performance of the queries needed to achieve it is quite bad.