Re: Full text separators

[Faury Rodriguez]

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