MySQL Forums
Forum List  »  Full-Text Search

Re: Full text separators
Posted by: Faury Rodriguez
Date: March 02, 2008 09:07PM

Semicolons are used as a separator.

According to, http://dev.mysql.com/doc/refman/5.0/en/fulltext-natural-language.html, a true word is defined as "any sequence of true word characters (letters, digits, and underscores)." Additionally, "that sequence may also contain apostrophes (“'”), but not more than one in a row. This means that aaa'bbb is regarded as one word, but aaa''bbb is regarded as two words." Any other character is considered a separator unless you are in boolean mode and it's a special syntax character defined in the variable, ft_boolean_syntax. See: http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#option_mysqld_ft_boolean_syntax
for info on those characters.

This link describes how to use the ftdump utility to see what words have been indexed. http://www.databasejournal.com/features/mysql/article.php/3512461

Options: ReplyQuote


Subject
Views
Written By
Posted
10747
January 04, 2008 04:50AM
Re: Full text separators
4333
March 02, 2008 09:07PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.