Full Test Searching Reference Table

Following is the syntax table used for full-text searching. All searching is case insensitive.

Examples

Type of Search

photos

Simple words

“Zasio Enterprises”

Phrase search

dog cat

The same as the search "dog" and "cat".

photos AND digital

AND

All words in search must be present to match.

photos OR photography

OR

Any word in search can be present to match.

photos AND NOT digital

AND NOT

All entries with the word "photos" but not the word "digital" will be found.  Cannot use NOT by itself.

"photo*”

photo*

Returns all "photo", "photo shop", "photography", etc. Without the quotes, it looks for exact occurrences of photo* (including the asterisks).

"ice cream*"

 

Returns all "ice cream", "iced cream", "ice creamy". Wildcard characters can be used in query expressions to expand word searches into pattern searches. The asterisks wildcard (*) specifies that any characters can appear in multiple positions represented by the wildcard. The presence of quotes around the items is significant.

dog NEAR cat

dog ~ cat

Use the NEAR, ~ operator to return results based on the proximity of two or more query terms.

“Idaho Photography” AND digital

"photo*" AND NOT digital

Combinations

*Requires the use of the # prefix

digital AND ("photo*" OR "pict*")

Grouped by ()

*Requires the use of the # prefix

O'Conner

 

 

Johnson

Punctuation such as single quotes and dashes that are significant characters in a word must be included when searching.

Returns “Johnson” or “Johnson?” – The ? is insignificant to the word and is ignored.

123-4567

“123 4567”

 

“123-4567*”

Returns “123-4567”, but not “123-4567-08”.

Returns “123-4567” or “123-4567-08”, but not “123-45678”. The dash is ignored (does not apply to all punctuation).

Returns “123-4567”, “123-45678”, “123-4567 A01”, or “123-4567-08”.