Hi all,
Does anyone know the formula that mysql use when calculating relevance scores from fulltext searches?
OR
Does anyone know a good way of calculating relevence percentages from search results using PHP? At the moment I'm calculating the percentage of how many search terms area found against how many unique words have been returned. However, this is giving me percentages between 1 and 10%. Obviously, this is correct, but how does everyone else do it?
Many thanks in anticipation
Tom
MySQL Fulltext search - formula?
Moderator: General Moderators
-
tom_gosling
- Forum Newbie
- Posts: 1
- Joined: Tue Jan 27, 2004 8:30 am
- Location: UK
Good question.
At a local PHP users group we talked about this one night. No one had a clue as to how the MySQL dev team created the relevance column. Some people had attempted to create their own system using percentages, stars, or some other scale. Nothing would work consistently though. I looked at this as well and gave up after a few hours. I have always wanted to contact MySQL about it but I either forget or get stuck doing other things.
Maybe you coud contact the MySQL General or Internals mailing lists and see what kind of a response you get. Short of looking at the MySQL source code it might be your best bet. I've done numerous google searches and forum searches and never found an answer.
Good luck.
Keith
At a local PHP users group we talked about this one night. No one had a clue as to how the MySQL dev team created the relevance column. Some people had attempted to create their own system using percentages, stars, or some other scale. Nothing would work consistently though. I looked at this as well and gave up after a few hours. I have always wanted to contact MySQL about it but I either forget or get stuck doing other things.
Maybe you coud contact the MySQL General or Internals mailing lists and see what kind of a response you get. Short of looking at the MySQL source code it might be your best bet. I've done numerous google searches and forum searches and never found an answer.
Good luck.
Keith