From: Nils Meyer (meyerhauptsache.net)
Date: Wed Mar 14 2007 - 05:54:41 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi John

John Nichel wrote:
> The db is MySQL 4.1.20 and the column synonyms_misspellings has a
> FULLTEXT index on it (the db is set to index on 3 characters). Can
> anyone help me understand why it's not rating the one with the match
> three times higher than the one with the match twice, and point me in
> the direction of how to make it work that way?

Try reading here, this should at least explain how rating works
http://dev.mysql.com/doc/internals/en/full-text-search.html

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]