I am working on an application where I want or rather need too switch the A [operater] B logic to B [operater] A.  

Say I have a two column table where the fields are Category and Name.

Example entries:
fruit, apple

fruit, orange

animal, dog

animal, cat

mineral, quartz

vegetable, carrot  

When creating a list view I could use a filter to show only one category:

Category contains [get param="category"]

With the query parameter ?category=fruit my list would return:

fruit, apple

fruit, orange  

But I would like to be able to return more than one category with a query like ?category=fruit,mineral to return in the view:

fruit, apple

fruit, orange

mineral, quartz  

If I could flip the test to "[get param="category"] contains |[id of Category field]|" that would make the most simple and direct sense but that isn't an option.  

I have a hard time believing that someone hasn't come across this desire (or need) and figured it out, but I'll be darned if I can figure out the right search terms to find the answer here or in the docs.

I have simplified it a bit from the actual in my description above but it should get the point across as to what I want to do dynamically. The values for category in my actual won't be passed in the query string but rather returned from a view that prints out something like "|fruit| |mineral|" based on assignment from another form by user ids (which categories the user should be able to see).

Thanks in advance for any help! Even if it is a link to the place I am not finding in the docs that would give me an ah ha moment. :)

-Ian