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]
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:[EMAIL PROTECTED]
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/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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/[EMAIL PROTECTED]
