Operators connecting terms
Boolean operators form the basis database logic.
They connect your search words together to either narrow or broaden your set of results.
The three basic Boolean operators are: AND, OR, and NOT.
Use AND in a search query to:
- connect different concepts
- narrow your results
- tell the database that ALL search terms must be present in the resulting records
Example: cloning AND animals AND ethics
Use OR in a search query to:
- connect two or more alternative terms of one concept
- broaden your results
- tell the database that ANY of your search terms can be present in the resulting records
Example: rabbits OR hares
Use NOT in a search query to:
- exclude words from your search
- narrow your search
- tell the database that occurrence of this word eliminates a record from results
Example: squirrel NOT flying
It is wise to write all the Boolean operators in CAPITAL LETTERS, since some databases might demand it and it also makes the search query more readable, since the terms and operators stand out from each other more easily.
Databases usually recognize AND as the primary operator, and will connect words with AND even if you don’t type it.
If you use a combination of AND and OR operators in a search, the OR-operations must be done before ANDs. This is done by enclosing the words connected with “OR” together in parentheses:
Example: (rabbits OR hares) AND cloning
In many databases you may use the advanced search form to build up your search with drop-down menu. See more from next chapter: Basic and advanced search.
Watch a video by Deakin Library (1:36) (video opens to YouTube):
- Recognise which of your search terms should be connected with AND, which with OR
Next page: Basic and advanced search queries