My Day✳All blog articles ↗

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.

3 records; 2 selected; 1 excluded
3 records; 2 selected; 1 excluded

What to do

  1. Choose one concept and put its alternative expressions into a single OR group.
  2. Add the second required concept with AND and make the first group explicit with parentheses.
  3. 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.

Buy My Day for Windows ↗