Question on full text search scores, different content same score

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

-----------------------------------------
Mark Steudel
NetRiver
Web and Application Developer
555 Dayton St.
Suite A
Edmonds, WA 98020
w: http://www.netriver.net
p: 425.741.7014



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

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/mysql?unsub=gcdmg-mysql@m.gmane.org

RE: Question on full text search scores, different content same score

Is there a way to escape the parenthesis?

-----Original Message-----
From: Gerald L. Clark [mailto:gerald_clark@suppliersystems.com]
Sent: Friday, June 09, 2006 6:18 AM
To: Mark Steudel
Cc: mysql@lists.mysql.com
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/mysql?unsub=mark@netriver.net




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org