Re: FULL TEXT results

2001-11-18 Thread Sergei Golubchik
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 >

FULL TEXT results

2001-11-18 Thread johnlucas-Arluna
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) AGAI