Search Help

Search supports the following operators:

Operator Description Example
+

A leading plus sign indicates that a word must be present in each row that is returned.

+join +union

Find rows that contain both words.

+join union

Search rows that contain the word 'join', but rank rows higher if they also contain 'union'.

-

A leading minus sign indicates that a particular word must not be present in any of the rows that are returned. The - operator acts only to exclude rows that are otherwise matched by other search terms.

+join -union

Find rows that contain the word 'join' but not 'union'.

Blank (no operator)

By default, the word is optional, but the rows that contain it are rated higher.

join -union

Search rows that contain at least one of the two words.

> <

These two operators are used to change a word's contribution to the relevance value that is assigned to a row. The > operator increases the contribution and the < operator decreases it.

+join +(>left <right)

Find rows that contain the words 'join' and 'left' or 'join' and 'right' (in any order), but rank 'join left' higher than 'join right'.

( )

Parentheses group words into sub-expressions. Parenthesized groups can be nested.

 
~

A leading tilde acts as a negation operator, causing the word's contribution to the row's relevance to be negative.

+join ~left

Find rows that contain the word 'join', but if the row also contains the word 'left', rate it lower than if row does not.

*

The asterisk serves as the truncation (or wildcard) operator. Unlike the other operators, it is appended to the word to be affected. Words match if they begin with the word preceding the * operator.

join*

Find rows that contain words such as 'join', 'joins', 'joining' etc.

"

A phrase that is enclosed within double quote ("match this phrase") characters matches only rows that contain the phrase literally, as it was originally typed.

"left join"

Find rows that contain the exact phrase "left join".