MySQL Full-Text Search Help | www.epaperarchives.com www.aiedv.ch

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').