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)