Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
As I understand it, if multiple search terms are input to a Search Box, results will be displayed for ANY matching term.
Is it possible to make the search return only where BOTH terms are found?
As an example, if I have 3 rows containing the following text ...
1 "Cheese"
2 "Onion"
3 "Cheese and Onion"
If I enter into a Search Box "Cheese Onion", I believe that I will get all 3 rows returned.
How can I enter a search where only the 3rd row "Cheese and Onion" is returned?
Many Thanks
Mark
Try a compound search
(*cheese* & *onion*)
See also
See if this application is helpful.
Thanks swuehl, perfect!
The Compound Search - demystified link is very helpul !
Thanks Sunny
Very clever, but I am particularly looking to enable multiple search terms over a number of fields - it looks like the compound search is what I am looking for
Really like your example though!