Is there a way to escape the parenthesis?
-----Original Message-----
From: Gerald L. Clark [mailto:[EMAIL PROTECTED]
Sent: Friday, June 09, 2006 6:18 AM
To: Mark Steudel
Cc: [email protected]
Subject: Re: Question on full text search scores, different content same
score
Mark Steudel wrote:
> I was doing a full text search and had a question on why two different
> entries got the same score:
>
> Here is my select statement
>
> SELECT
> id,
> pubyear,
> MATCH ( title ) AGAINST ( 'Nursing home federal requirements, guidelines
to
> surveyors, and survey protocols (MLM)' ) AS score,
> title
> FROM tblbook
> WHERE MATCH ( title ) AGAINST ( 'Nursing home federal requirements,
> guidelines to surveyors, and survey protocols (MLM)' )
>
> Here are the two results that come back:
>
> title: Nursing home federal requirements, guidelines to surveyors, and
> survey protocols
> score: 15.230528838754
>
> title: Nursing home federal requirements, guidelines to surveyors, and
> survey protocols (MLM)
> score: 15.230528838754
>
> I'm sure its work as expected, but I was hoping some could enlighten me as
> to why these scores are the same. There are 35 entries in the database and
> these are the only two titles that are similar. I also tried IN BOOLEAN
MODE
> as well.
>
> Thanks, Mark
>
Perhaps because '(' and ')' are ignored, and 'MLM' is a three letter
word, and not indexed.
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
