We use the words AND, OR, and NOT everyday in conversation without even thinking about them. But when we use these common words in a search engine (like Google), the library catalogue, or a database they become powerful search tools.
This guide will introduce you to the basics of using Boolean Operators, so that you can get better results when searching for books and articles.
Operator |
Examples |
Results |
AND |
|
Retrieves records that contain |
OR |
|
Retrieves records that contain |
NOT |
|
Excludes records containing |
Boolean operators form the basis of mathematical sets and database logic.
Why use Boolean operators?
Use AND in a search to:
The purple triangle in the middle of the Venn diagram below represents the result set for this search. It is a small set using AND, the combination of all three search words.
Be aware: In many, but not all, databases, the AND is implied.
Use OR in a search to:
All three circles represent the result set for this search. It is a big set because any of those words are valid using the OR operator.
Use NOT in a search to:
Too much info? Not finding enough?
Narrower or broader your search.
How? Keywords will vary your results.
Use Help
Each search tool has a Help file which will show you how to get the best results.
If your initial search query does not produce the desired results, try these search strategies.
Search Strategies | Examples |
Queries are not case sensitive. |
Barack Obama and barack obama will retrieve the same results.
|
Results will typically include each word or punctuation mark included in the search query. Some stop words or exceptions apply. |
|
Keep search queries simple and descriptive and use as few terms as possible. Avoid natural language queries as they can limit your results. |
Use colorado statehood instead of when did colorado first become a state. |
Google automatically truncates search terms. To prevent automatic truncation, use a + sign in front of each term. |
A query on child retrives results with 'children" and "childcare". |
Use double quotations marks ("") to search terms as a phrase and narrow your results. Google will only retrieve results that have those exact terms in the exact order typed. |
A query on Barack Hussein Obama II will retrieve only those sites that refer to Obama by his full name. Sites that refer to him as simply 'Barack Obama' may be overlooked. |
Use the site: feature to limit your results to a specific website or class of websites. |
The query cloning site:online.wsj.com will only retrieve articles about cloning from the online version of the Wall Street Journal. A query on cloning site:.gov will only retrieve results within the government domain. |
To allow for either of several words to appear in your results, use the OR operator. The operator must be in all caps. |
A query on hotel OR lodging OR inn directories will retrieve any or all of the types of directories mentioned. |