Hum, I'm using mysql fulltext searches for a script of mine, theoretically it's pretty simple but as normal I encounter annoying perculiarities.

I have one record in my table containing the words "test" and a few other words of no importance.....when I do a search for "test"....I get a result...woohoo.....

_But_ if I do a search for "blurp" I still get one result...huh?

SELECT * FROM Table WHERE MATCH (Col1, Col2) AGAINST ('blurp')

Have I lost my mind yet again?

(I'm thinking of resorting to LIKE)

Hi Paul,

Yup, I didn't like FULLTEXT in MySQL 3.x, or even 4.01. I would get really strange results. What does SELECT Co1,Col2 FROM Table give you?

Cheers,

Alex
--
Gossamer Threads Inc.

The query you suggested returns the row.

I was more interested in what was in the row to see why it would match..

Cheers,

Alex
--
Gossamer Threads Inc.

It returns:

Col1:
Testing the KB

Col2:
This is the main faq body..