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]