MySQL Fulltext search - formula?
Posted: Tue Jan 27, 2004 8:30 am
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
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