Filtering on part of string

Hello,

I'm trying to design a report, off of which I'll produce charts. I want to create a filter with several "contains" values. Here's what I mean:

Let's say hypothetically, you have a "fruit baskets" table. This table has 2 fields: FruitBasketNumber and Contents. "FruitBasketNumber" is your primary (super) key and "Contents" is just a string with the contents of the basket.

So an example record might be:

FruitBasketNumber | Contents

#1 | Apples**Oranges**Pears**Plums**Melons**Bananas**

I want to be able to create "buttons" that let users select records that contain one or more parts of the string (e.g. "Apples", "Oranges", etc). So, a user should be able to press the "filter" button, select "apples", and see all records where apples are somewhere in the contents. A user should be able to select "Apples" and "Bananas" and see only FruitBaskets which have both Apples and Bananas. I do not consider it a good enough solution that a user can type in "apples".

The closest thing I've found so far is selecting "contains" in advanced filters, but I'm not sure what this is supposed to do. It seems to filter in the report creation rather than create the option to filter (I'm assuming that I just don't understand the mechanics).

Any ideas? How do I accomplish this?

Thank you very much.