A database search example using all of the tips below: Boolean, truncation and phrase searching
Boolean operators (connector words) such as AND, OR, and NOT, create phrases based on rules of search logic.
Operator | Examples | Results |
AND |
|
Retrieves records that contain ALL of the search terms. |
OR |
|
Retrieves records that contain ANY of the search terms, but does not necessarily include all of them. |
NOT |
|
Excludes records containing the second search term. |
Truncation
The “ * ” replaces any number of characters and will find all forms of a word root.
Wildcard
Note: symbols used may differ based on the tool used. Consult the help documentation.
Wildcard " # " replaces any extra characters that may appear in alternative spellings.
Wildcard " ? ” replaces one character
Phrase searching
increases the accuracy of the search by keeping two or more words together as a phrase. Use quotation marks to keep the phrase intact.
“social media” "fairy tale" "fake news"