To achieve this:

• Click the search bar drop down arrow
• Click Advanced Search
• Set up a condition on any suitable field.
• Hit Apply.
• For your example, you can achieve the desired result by setting up 2 separate filters, the first has a condition on the field Name and its value is t-shirt, the other one has the value black
• This way you can achieve the AND behavior.

Note: To achieve the OR behavior using this same method, all you have to do is create a filter with several conditions.

To sum it up:

• Multiple filters with one condition each = AND
• One filter with several conditions = OR

I am also wondering this because I have over 3000 products and can't remember how they are exactly worded, so try to find product based off words out of order and only partial, the % works to an extent if I can remember what order the words show up in, but would like to find a solution that shows all results regardless of search order ​

Hi, there is kind of a way to achieve this functionality by using "%"-sign in searches. It is not perfect in any means but works somehow.

br juha