Many Databases have extra hidden search commands that only work in their database. These are extremely useful BUT differ between databases, so consult the directions for each database before using them
- Readex
- asterisk (*) matches multiple characters.
- Woman* = woman, womans, womanhood
- hea*one = headphone, headstone, healthone, hearthstone, heartstone, heatherstone
- question mark (?) replaces a single letter in a word.
- Near Operator NEAR# will return results where words are close together, regardless of order
- woman NEAR7 colleges = woman and colleges within seven words apart in any order
- Adjacency Operator ADJ# will return results where words are close together, in that order
- Women ADJ5 colleges = colleges within the last 5 words after women.
- EBSCO
- asterisk (*) matches multiple characters.
- Woman* = woman, womans, womanhood
- hea*one = headphone, headstone, healthone, hearthstone, heartstone, heatherstone
- hash sign (#) matches one optional character.
- question mark (?) matches exactly one character.
- Near Operator (N) will return results where words are close together, regardless of order
- Women N5 colleges = women and colleges within 5 words of each other
- Within Operator (W) will return results where words are close together, in that order
- Women W5 colleges = colleges within the last 5 words after women.
- ProQuest
- asterisk (*) matches multiple characters.
- Woman* = woman, womans, womanhood
- Only works at end of word
- No hashtag search in ProQuest
- question mark (?) matches exactly one character.
- wom?n = woman, women
- Can be used multiple times.
- ad??? = ad, ads, adds, added, adult, adopt
- Near Search, NEAR/# finds terms within # words apart in any order
- woman NEAR/7 colleges = woman and colleges within seven words apart in any order
- Within Search, PRE/# or P/#, finds terms within # words apart in that order
- woman PRE/7 colleges = searches were colleges is listed within 7 searches after woman
- Gale
- Asterisk (*) matches multiple characters, but only at end of the word
- Woman* = woman, womans, womanhood
- Question mark (?) replaces exactly 1 character.
- Exclamation (!) stands for one or no character.
- Near search N# finds terms within # words apart in any order
- woman N4 colleges = women and colleges 4 words apart
- Within search W# finds terms within # words apart in that order
- woman W4 colleges = results where college is within 4 words after woman.
- WorldCat
- Asterisk (*) matches multiple characters, but only at end of the word
- Needs at least 3 letters preceding it
- Hash sign (#) replace one character.
- Question mark (?) Replace 0 to 9 unknown characters in a search term. Works in the middle of a word
- colo?r = color, colour
- if followed by a number, you can limit how many letters are changed.
- res?4tion = respiration, restoration, reservation
- Near (n#) finds both terms, in any order, within # words (only up to 25)
- women n10 colleges = colleges and women within 10 words in any order
- Within (w#) finds both terms, in the order typed, within # words (only up to 25)
- women w10 colleges = colleges no more than 10 words after women
Please note that many databases works differently, so you need to read the about page. For example:
- GoogleBook uses AROUND(#) for proximity search while British History Online uses "word1 word2"~#
- Googlebook example: woman AROUND(5) colleges = woman and colleges 5 words apart
- BHO example: "women colleges"~5 = woman and colleges 5 words apart
- Note this is weird instance where "" isn't a phrase search. Very weird
- Some databases, like Chronicling America, have a special search box specifically for proximity searches.
- See Columbia Guide to Proximity Operators
"Proximity operators are an important tool for focusing the results of free text searches, particularly in full-text databases. Sadly, there is little uniformity in the syntax for proximity searching across various database families. The chart below, created by DHC Head Bob Scott, provides a key to some of the databases found on the Columbia Libraries website. The first column indicates the publisher name and then a few of the resources from that publisher. The next column indicates the syntax for a search of records where the search terms occur within the indicated number of words in either order, and the third column provides the syntax when searching for words, where the second word must follow the first word."