Search feature explained

Printer icon

Search feature explained

Fulltext search - normal

The fulltext search is powerful and accurate. In "normal" mode it returns all the posts containing the words as are written in the input search form.

Fulltext search - boolean

The "boolean" mode is even more accurate. If the word to search for is entered without any parameters it is simply searched for as in "normal" mode otherwise it enables the user to define the search using the following parameters:

+A leading plus sign indicates that this word must be present in every result returned
-A leading minus sign indicates that this word must NOT be present in any result returned
><These two operators are used to change a word's contribution to the relevance value that is assigned to a result. The > operator increases the contribution and the < operator decreases it.
()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 result relevance to be negative. It's useful for marking noise words (the, and, or, etc.). A row that contains such a word is rated lower than others, but is not excluded altogether, as it would be with the - operator.
" "A phrase that is enclosed within double quote characters matches only rows that contain the phrase literally, as it was typed.

The downside of FULLTEXT search is that the default minimum length of a word is 4 letters, which for a web log is pretty bad since words like CSS, CMS, XML and PHP are excluded. This can be changed manually in the my.cnf file by setting ft_min_word_len to 3 as has been done for this site.