The search capability supports the following operators:
A phrase that is enclosed within double quote (“"”) characters matches only rows that contain the phrase literally, as it was typed.
A leading plus sign indicates that this word must be present in each row that is returned. See the example section below for more help.
A leading minus sign indicates that this word must not be present in any of the rows that are returned.
Note: The - operator acts only to exclude rows that are otherwise matched by other search terms. Thus, a search that contains only terms preceded by - returns an empty result. It does not return “all rows except those containing any of the excluded terms.”
When neither + nor - is specified, the search will look for matches on one or more of the words entered. This is equivalent to an OR search.
The asterisk serves as the truncation (or wildcard) operator. Unlike the other operators, it should be appended to the word to be affected. Words match if they begin with the word preceding the * operator.
The following examples demonstrate some search strings that use boolean full-text operators:
Find rows that contain at least one of the two words.
Find rows that contain both words.
Find rows that contain the word “apple”, but rank rows higher if they also contain “macintosh”.
Find rows that contain the word “apple” but not “macintosh”.
Find rows that contain words such as “apple”, “apples”, “applesauce”, or “applet”.
Find rows that contain the exact phrase “some words” (for example, rows that contain “some words of wisdom” but not “some noise words”).