More advanced searching....

[GoBlue!]

Are there any boolean commands or other advanced search commands available?

Jim

 

[Ted S]

During our upgrade I searched the forum to mysql fulltext searching which supports a lot of the standard boolean commands as explained at http://dev.mysql.com/doc/mysql/en/Fulltext_Boolean.html.

The boolean full-text search capability supports the following operators:

+
A leading plus sign indicates that this word must be present in every row returned.
-
A leading minus sign indicates that this word must not be present in any row returned.
(no operator)
By default (when neither + nor - is specified) the word is optional, but the rows that contain it will be rated higher. This mimics the behavior of MATCH() ... AGAINST() without the IN BOOLEAN MODE modifier.
> <
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 subexpressions. 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 row 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 rows that contain the phrase literally, as it was typed.

 

[GoBlue!]

thanks so much. Is it a single post or a whole thread that's considered one "row?"
Guess I could figure it out by trial & error.

Jim