Re: Fulltext search question: words with numbers (ie DB2)

[Brent Baisley]

Not as far as I know. Boolean forces all matches to have all the words 
searched on, rather than relevance ranking the results based on how 
many of the specified search words are in a record. Searching in 
boolean mode will always return the same or less results than a regular 
full text search.

On Mar 31, 2004, at 11:21 AM, Shane Allen wrote:

Brent Baisley wrote:

The other thing to consider is the 50% rule. If more than 50% of the 
records match, the search is consider irrelevant and no records are 
returned. So if you have 120 records and 61 have DB2 in them, you 
won't get a result set.
But the 50% rule is overridden when the search is in boolean mode, 
isn't it?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/[EMAIL PROTECTED]


--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]