Skip to Main Content

Writing 101

Boolean Searching

Boolean operators form the basis of mathematical sets and database logic.

  • They connect your seach words together to either narrow or broaden your set of results.
     
  •  The three basic boolean operators are: ANDOR, and NOT.
     

Why use Boolean operators?

  • To focus a search, particularly when your topic contains multiple search terms. 
  • To connect various pieces of information to find exactly what you're looking for.

More fun with Boolean searching:

Truncation 

To increase the number of hits retrieved, you might consider using a truncation symbol.  Truncation will pick up variations of a word stem. Truncation symbols vary, depending on the database.

    e.g., critic* will find critic, critics, criticism, critical, etc.


Wildcard

The wildcard symbol can be used to replace one letter in a word. This will instruct the computer to do a search and match all letters in the word and use any letter to replace the wildcard symbol.

    e.g., Wom?n will retrieve records with woman and women.


and did you know that you can use these techniques in the library catalog?   search engines?

HENRY example:
(keyword search only) by using biofuel* and energy --- there are 11 titles that contain those keyword

AND

Use AND in a search to:

  • narrow your results
  • tell the database that ALL search terms must be present in the resulting records
  • example: cloning AND humans AND ethics

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.
    • For example, Google automatically puts an AND in between your search terms.
  • Though all your search terms are included in the results, they may not be connected together in the way you want.
    • For example, this search:  college students test anxiety  is translated to:  college AND students AND test AND anxiety. The words may appear individually throughout the resulting records.
  • You can search using phrases to make your results more specific.
    • For example:  "college students" AND "test anxiety". This way, the phrases show up in the results as you expect them to be.

OR

Use OR in a search to:

    • connect two or more similar concepts (synonyms)
    • broaden your results, telling the database that ANY of your search terms can be present in the resulting records
    • example: cloning OR genetics OR reproduction

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.

NOT

Use NOT in a search to:

  • exclude words from your search
  • narrow your search, telling the database to ignore concepts that may be implied by your search terms

example:  cloning NOT sheep