Hi
Having a few weird things with the FULL text Match, it's bringing back
records where there is definitely no match but the score is above 1.
Using the following SQL:
SELECT tblText.ID, tblText.Title, MATCH (pagetext) AGAINST ('thornham
manga') AS score FROM tblText WHERE MATCH (pagetext) AGAINST ('thornham
manga') GROUP BY tblText.BrID, tblText.CoID ORDER BY Score DESC
I get the correct document at the top of the results (1.49300164126801), but
then lots of other records with the same score (1.2220865010391), even
though they do not contain the words to match.
The collection is very small, only 278 records at the moment, perhaps that's
causing the problem, but it would be good if we could tweak it to return the
correct results.
Does anyone have any ideas?
Thanks a lot for any help.
John.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
