Think about. If if a book has many tags, and any of them are not apples and not oranges, you will get that book, including if they also have apples and/or oranges.
Example: a book has tags: apples,oranges,peaches,pears.
Your search would return that book because peaches are not apples and are not oranges. Ditto for pears.
This is true for any metadata column that is "multiple". If you were searching a straight-up single metadata column such as publisher, your search would be fine.
DaltonST
|