Full-text search lets you find articles containing the word(s) specified in the field
Fulltext Search .
Articles may be searched for multiple words.
The words must be separated by a space like: apple wine earth
The full-text search capability supports the following operators:
+ |
A leading plus sign indicates that this word must be present.
|
- |
A leading minus sign indicates that this word must not be
present.
|
(no operator) |
By default (when neither + nor
- is specified) the word is optional,
but when contained it will be rated higher.
|
> < |
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.
See the example below.
|
( ) |
Parentheses are used to 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 relevance to be negative. It's useful for marking
noise words. A text that contains such a word will be rated lower than
others, but will not be excluded altogether, as it would be with the
- operator.
|
* |
An asterisk is the truncation operator. Unlike the other operators, it
should be appended to the word.
|
" |
A phrase that is enclosed within double quote
(") characters matches only
text that contain the phrase literally, as it was typed.
|
The examples demonstrate some search strings:
apple banana |
Find rows that contain at least one of the two words.
|
+apple +juice |
Find rows that contain both words.
|
+apple tree |
Find rows that contain the word 'apple', but rank rows
higher if they also contain 'tree'.
|
+apple -tree |
Find rows that contain the word 'apple' but not 'tree'.
|
+apple +(>tree <strudel) |
Find rows that contain the words 'apple' and 'tree',
or 'apple' and 'strudel' (in any order),
but rank 'apple tree' higher than 'apple strudel'.
|
apple* |
Find rows that contain words such as 'apple', 'apples',
'applesauce', or 'applet'.
|
"some words" |
Find rows that contain the exact phrase 'some words' (for example, rows
that contain 'some words of wisdom' but not 'some noise words').
|