Skip to Main Content
Westchester Community College Harold L. Drimmer Library

Database Searching: Boolean Operators

This guide describes a variety of search techniques that can be used to help improve your database search results. The techniques can be used in any database, but this guide is based on searches performed within Academic Search Complete.

Which Operator Should I Use?

You have to experiment with different search strategies when you are doing research. Sorry, there's just no way around it. Boolean Operators can help you save time because they can improve your search results, but it's important to know when and why to use each one.

For example, let's use the research question "Do soft drinks contribute to childhood obesity?" Most databases give you the option to select Boolean Operators right on the search screen, so all you have to do is select the operator you want from a drop down box between search lines.

Here's our advice:

Use AND when your research topic has more than one key term/idea that must be present in all of your search results. In this example, the key points are "soft drinks" and "childhood obesity." Searching with AND gives you fewer results because you're telling the database that you will only accept results that include both of your search terms.

 

 

 

 

 

 


Use OR when your research topic has synonyms which different authors may use interchangeably, for example "soft drinks" and "soda." This way, you won't miss out on potentially important search results because a paper or book was written with different wording than you are searching under. Searching with OR gives you more results, because you are telling the database that you're willing to accept any result that includes at least one of your search terms.

 


Use NOT when your research topic is often closely associated with another concept you do not want information about, for example if you are researching soft drinks and childhood obesity, but do not want information about vending machines in schools. Searching with NOT gives you fewer results because you're telling the database that you will only accept results that include one of your search terms by itself.

 

 

 


 

Boolean Operators (Video Tutorial)

Other Helpful Pages

Other helpful pages

  • Boolean Quick Reference
    This PDF from Glendale Community College includes brief examples and diagrams showing various Boolean searches. 

Celebrating 75 Years of Excellence!

Westchester Community College provides accessible, high quality and affordable education to meet the needs of our diverse community. We are committed to student success, academic excellence, workforce development, economic development and lifelong learning.

MyWCC
Facebook Facebook Facebook Facebook Facebook

75 Grasslands Road
Valhalla, NY 10595
Tel: (914) 606-6600