How to search by "logical AND" or "logical OR"

[Taufan]

Hi,
Is it possible to search by “logical AND” or “logical OR”.

Example:

What I want to achieve is to display columns that have ONLY the words “apple” and “fruit”.

Thanks for your help.
I really appreciated.
Sorry for my English, I hope you understand.