Skip to Main Content

Database Help: Searching in a Database

Searching in a Database - Search Operators

  • Operators determine how your search terms are combined in the search.
  • They are sometimes called BOOLEAN operators (named after George Boole, a mathematician).
  • The three main operators are ANDOR, and NOT. It's best to type them in using capital letters.

The AND operator gets results where all search terms are included

 

Using the AND operator

  • When you search in a database, you might get too many results. 
  • If you add extra search terms, and combine them with AND, you will get only results that contain both or all of the terms.
  • This is a way of making your search more specific (narrower), and getting fewer results.

 


 

The OR operator gets results with one or other, or both, of your search termsUsing the OR operator

  • Sometimes you might not get enough results.
  • If you add extra search terms, and combine them with OR, you will get results that contain one or other (or both) of your search terms.
  • This is a way of ensuring that you search for all terms that might be used in the literature. It makes your search less specific (broader), and you should get more results.

 

 

Using the NOT operator

  • Sometimes you might wish to get results that exclude certain terms.
  • If you add these terms with the NOT operator, you will exclude results that have those terms.
  • This is a way of making your search more specific (narrower), and getting fewer results.
  • NOTE: it might be better to search for what you do want, rather than what you do not want.

Example:  government NOT state


Nesting

  • If you use different operators in the same search, you must use either round brackets or separate search lines. This is important to control the way the operators are applied in the search. 
One line of search Multiple lines of search
(politics OR government) AND (history OR past) AND australia politics OR government
[AND] history OR past
[AND] australia

Charles Sturt University acknowledges the traditional custodians of the lands on which its campuses are located, paying respect to Elders, both past and present, and extend that respect to all First Nations Peoples.Acknowledgement of Country

Charles Sturt University is an Australian University, TEQSA Provider Identification: PRV12018. CRICOS Provider: 00005F.