Guide

Boolean Search Operators for Research: AND, OR, NOT

Boolean search operators are the words AND, OR and NOT, which tell a database how to combine your search terms: AND narrows results to records containing every term, OR broadens them to records containing any of the terms, and NOT excludes a term. Combined with parentheses, quotation marks and truncation, they let you build one precise search that would otherwise take a dozen.

Last updated 9 min read

Research skills

Key takeaways

  • AND narrows a search, OR broadens it and NOT excludes, with AND and OR doing most of the work in a good search.
  • Put synonyms for one concept together with OR inside parentheses, then join the concept groups with AND.
  • Quotation marks keep phrases together, and an asterisk catches word endings in most library databases.
  • Use NOT sparingly, because it removes every record that mentions the excluded term, including relevant ones.
  • Syntax varies between databases and search engines, so check each help page and log the strings you run.

AND, OR and NOT: what each Boolean operator does

Each operator changes the size of your result set in a predictable way. Picture two overlapping circles, one for each term: AND gives you only the overlap, OR gives you everything in both circles, and NOT gives you one circle with the overlap cut away.

Many databases expect operators in capital letters, so type AND, OR and NOT in capitals as a habit. Typing several words with no operator between them is often treated as AND, but do not assume it: some systems treat a string of words as a phrase, or rank results by loose relevance instead.

OperatorWhat it doesExampleEffect on results
ANDRequires every term to appearsleep AND adolescentsFewer, more focused results
ORAccepts any of the termsadolescents OR teenagersMore results; use it for synonyms
NOTExcludes records containing a termsleep NOT apneaFewer results, at the risk of losing relevant ones
The three Boolean operators at a glance
IllustrationTwo overlapping circles on a chalkboard: AND is the overlap, OR is everything inside both.

Parentheses, phrases, truncation and proximity

The three operators become far more powerful with four companions. Support and exact symbols differ between databases, so check the help page of each one you use.

Parentheses

Parentheses group terms so the database processes them together, as in arithmetic. (teenagers OR adolescents) AND sleep finds records about sleep that mention either word. Without the parentheses, a database might read the string as teenagers OR (adolescents AND sleep) and return every record that mentions teenagers. Databases differ in which operator they apply first, so use parentheses whenever you mix AND and OR.

Quotation marks

Quotation marks keep a phrase together: "social media" finds that phrase, while the same words without marks may match two separate parts of a record. Use them for established terms, not for ideas that authors word in many different ways.

Truncation and wildcards

Truncation, usually an asterisk, finds every ending of a word stem: adolescen* finds adolescent, adolescents and adolescence. Cut too short and you collect noise, since cat* also finds catalog and catastrophe. A wildcard, often a question mark, stands in for one character, so wom?n finds woman and women; some databases offer another symbol for an optional character, which helps with spellings such as behavior and behaviour.

Proximity operators

Some databases let you require two words to appear near each other, with operators such as NEAR/3 or W/5, where the number is the maximum distance in words. Proximity syntax varies more than any other kind, so check before you rely on it.

How to build a Boolean search string, step by step

The most reliable method is to work from your research question to a concept table, and from the table to a search string. Suppose your question is how social media use relates to sleep in teenagers. If you do not yet have a focused question, start with the guide to writing a good research question.

Followed through, the steps below turn that question into a string like this: (teen* OR adolescen* OR "young people") AND (sleep OR insomnia OR bedtime) AND ("social media" OR smartphone* OR "screen time"). Each pair of parentheses holds one concept, and every record returned must match at least one term from each group. Here is the method:

  1. 1Pick out the two to four core concepts in your question: here, teenagers, sleep and social media.
  2. 2For each concept, list synonyms, related terms, spelling variants and the technical terms researchers use.
  3. 3Join the terms within each concept with OR, and wrap each group in parentheses.
  4. 4Join the concept groups to each other with AND.
  5. 5Add quotation marks to fixed phrases and truncation to word stems.
  6. 6Run the search, read the first twenty or so titles, and adjust any term that pulls in noise or misses obvious matches.
  7. 7Save the final string, the database and the date in a search log, so you can rerun or report it.

Too many results or too few? How to adjust

Your first search is a draft. Look at the result count and, more importantly, the first page of titles. The records that are exactly what you wanted teach you the most: their titles, abstracts and subject headings show the vocabulary researchers actually use, which is often different from yours. Add those terms to your concept table, because a second round built on borrowed vocabulary usually beats the first.

Beyond borrowing vocabulary, adjust according to what the first page tells you:

  • Too many, mostly irrelevant: add a concept group with AND, limit key terms to the title or abstract field, or apply the database's filters for date, language or document type.
  • Too many, mostly relevant: narrow your question rather than your search, then add the new concept.
  • Too few: remove the least essential concept, add synonyms with OR, loosen phrases that authors may word differently, or check your truncation.
  • None at all: look for a typo, an unmatched parenthesis or a stray quotation mark before deciding the topic is empty.
IllustrationA first page of results examined closely, to borrow the vocabulary of the records that matched best.

Boolean search in library databases, Google and Google Scholar

Library databases support Boolean logic most fully. Many add field searching, so you can require a term in the title, abstract or author field, and controlled subject headings, standardized terms assigned to each record; PubMed's MeSH headings are a well-known example. Searching a subject heading alongside your keywords catches records that describe your concept in words you did not think of.

Google and Google Scholar handle Boolean logic more loosely. Both treat a space between words roughly as AND, accept OR in capitals, use a minus sign in place of NOT, and support quotation marks for phrases. Neither handles nesting and truncation the way databases do, so keep strings for them short. The guide to using Google Scholar effectively covers its operators in detail.

Common Boolean search mistakes

Once your searches are working, the guide to finding credible sources covers how to judge what they return. Until then, these errors account for most frustrating searches, so check for them before you decide your topic has nothing written on it:

  • Using AND between synonyms, as in teenagers AND adolescents, which demands both words and shrinks results.
  • Overusing NOT, which removes records that discuss your topic and merely mention the excluded term.
  • Mixing AND and OR without parentheses, leaving the database to guess the grouping.
  • Truncating too early, so the stem matches unrelated words.
  • Typing operators in lowercase in a database that reads them as ordinary words.
  • Searching full sentences in a database built for keywords.
  • Never checking the subject headings of good results for better terms.
On Cavua

How Cavua helps you refine your search terms

Cavua does not run database searches, but it helps with the step that makes Boolean strings good: finding the vocabulary your sources actually use. Once a first search turns up a handful of strong papers, upload them to your Work space and ask across all of them at once which terms they use for each of your concepts. Answers point to the page, so you can see each term in context before adding it to an OR group.

The same documents then work as a test set: ask which of them address all your concepts together, and tune your next search to find more like those. You can also chat with the tutor about a paper's methods or use โ€œQuiz meโ€ on it, with how much you can use depending on your plan, as shown on the pricing page.

Questions

Frequently asked questions

Something else? Email support@cavua.ai.

  • 01What are the three Boolean operators?

    The three Boolean operators are AND, OR and NOT. AND requires every term to appear and narrows a search; OR accepts any of the terms and broadens it, which suits synonyms; NOT excludes records containing a term. Most databases also support parentheses for grouping, quotation marks for phrases and truncation symbols for word endings.

  • 02Does Google use Boolean search?

    Partly. Google treats a space between words roughly as AND, accepts OR in capital letters, uses a minus sign in place of NOT, and supports quotation marks for exact phrases. It does not handle nested parentheses or truncation the way library databases do, so long strings built for a database often behave unpredictably there.

  • 03Do Boolean operators need to be capitalized?

    In many databases, yes, and everywhere else capitals are the safest habit. Some systems treat lowercase and, or and not as ordinary words or ignore them, which silently changes your search. Typing AND, OR and NOT in capitals works in every system that supports Boolean logic, so make it your default.

  • 04What is the difference between AND and OR in a search?

    AND narrows a search by requiring every term to appear in a record, so sleep AND adolescents returns only records mentioning both. OR broadens it by accepting any of the terms, so adolescents OR teenagers returns records mentioning either. Use AND between different concepts and OR between synonyms for the same concept.

  • 05What does an asterisk do in a database search?

    In most library databases the asterisk is the truncation symbol: it matches any ending on a word stem, so educat* finds educate, education, educational and educator. Place it carefully, because a stem that is too short pulls in unrelated words. A few databases use a different symbol, so check the help page if results look odd.

  • 06Why does my Boolean search return no results?

    Usually because of a syntax error, such as a missing parenthesis, an unclosed quotation mark or a typo, or because the search is too narrow. Check the string first, then remove the least essential concept, add synonyms with OR and loosen exact phrases. If it is still empty, borrow terms from related records.

Research skills

Study it with a tutor beside you.

Every Cavua course comes with a 24/7 tutor you can video call, speak to or chat with โ€” on the material you are actually studying.