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