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

[Brent Baisley]

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.

On Mar 31, 2004, at 12:28 AM, Shane Allen wrote:

apologies, I forgot to mention that.

I was aware of this, and just finished changing the ft_min_word_length 
to 2 and rebuilding my indexes.

searches for 'SAS' or 'net' yield results as expected, but DB2 still 
does not.

--
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]

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

[Shane Allen]

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]

Fulltext search question: words with numbers (ie DB2)

[Shane Allen]

I have a table with the following:

CREATE TABLE foo (
...
description text,
...
FULLTEXT INDEX (description),
...
);
select count(*) from foo where description like '%db2%';

returns 61 rows. Checking them confirms that the word db2 exists as a 
standalone word separated either by punctuation or spaces  in several of 
those documents

using MATCH(description) AGAINST('+db2' IN BOOLEAN MODE) returns no results.

Is this expected behaviour? If so, is there a way to circumvent it?

TIA

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

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

[Richard Davey]

Hello Shane,

Wednesday, March 31, 2004, 5:43:10 AM, you wrote:

SA using MATCH(description) AGAINST('+db2' IN BOOLEAN MODE) returns no results.
SA Is this expected behaviour? If so, is there a way to circumvent it?

By default, the full text indexing engine doesn't include words with
less than 4 characters in. If you are using MySQL 4 you can change the
minimum length via the ft_min_word_len variable. On MySQL 3.x
there's nothing you can do short of changing the actual source code
and recompiling.

-- 
Best regards,
 Richard Davey
 http://www.phpcommunity.org/wiki/296.html



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

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

[Shane Allen]

Richard Davey wrote:

Hello Shane,

Wednesday, March 31, 2004, 5:43:10 AM, you wrote:

SA using MATCH(description) AGAINST('+db2' IN BOOLEAN MODE) returns no results.
SA Is this expected behaviour? If so, is there a way to circumvent it?
By default, the full text indexing engine doesn't include words with
less than 4 characters in. If you are using MySQL 4 you can change the
minimum length via the ft_min_word_len variable. On MySQL 3.x
there's nothing you can do short of changing the actual source code
and recompiling.
 

apologies, I forgot to mention that.

I was aware of this, and just finished changing the ft_min_word_length 
to 2 and rebuilding my indexes.

searches for 'SAS' or 'net' yield results as expected, but DB2 still 
does not.

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