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]