Hi!
On Nov 18, johnlucas-Arluna wrote:
> 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.
>
Being a collection very small, can you please upload it gzipped to
ftp://support.mysql.com/pub/mysql/secret/ together with a description of
the problem ?
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/
---------------------------------------------------------------------
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
