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.

[Steve]

The built-in search bar does not provide for logical operators; it is a simple literal (but case-insensitive) text match.

[Fabian_Weller]

Hi @Steve would it be possible to add search operators like these? Feature Request?

[Steve]

Please post this to the Feature Request category.

[Fabian_Weller]

Search Operators Feature Requests

I would like to use search operators in the search box. [image] * = any text ? = any character " " = exact phrase & = AND | = OR ! = NOT () = group

[ChristianBolle]

The only possibility you have then is to go to the filter function, and the word apple, and search in the search bar for fruit, then these two words do not have to be side by side, but appear somewhere in the text.