Group synonyms before combining search concepts
Test OR and AND on a small, explicitly defined set of records.
Separate alternatives for one concept from another required condition. OR accepts either alternative, including both together; AND requires the conditions together. Parentheses show which alternatives belong in one group. Check the actual database’s rules before using the query there.
What to do
- Choose one concept and put its alternative expressions into a single OR group.
- Add the second required concept with AND and make the first group explicit with parentheses.
- Test the query against stated matching and nonmatching records before trying a real database.
Example
Fictional title-matching model: ("study notes" OR "learning notes") AND adults. R1 contains study notes and adults; R2 contains learning notes and adults; R3 has study notes without adults. Of 3 records, 2 qualify and 1 does not. These are defined examples, not search results.
My Day · Windows
Save the query and test records in My Day; you submit database searches yourself.