Bug #2559 Relevancy and fine-tuning MySQL Full-text Search
Submitted: 29 Jan 2004 9:51 Modified: 4 May 2007 11:49
Reporter: Clay Webster Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server Severity:S4 (Feature request)
Version:5 OS:Linux (Linux)
Assigned to: CPU Architecture:Any
Tags: ufr

[29 Jan 2004 9:51] Clay Webster
Relevancy needs some help and you say it's on the top of 
your todo list.  Weighting the FULLTEXT index would help.

How to repeat:
Have many fields in a record.  Half are FULLTEXT indexed. 
One field is three times more important than the others if
matches are found there.

Suggested fix:

It would be great to be able to add weights to fields that 
compromise the FULLTEXT index at index build time.
[13 Apr 2005 15:27] Joshua Wilson
It would also be nice to add fulltext to innodb table type.
[4 May 2007 11:49] Hartmut Holzgraefe
submitted twice, bug #2560 has more feedback