Gossamer Forum: General: Databases and SQL: MySQL FullText: Edit Log

Gossamer Threads

Home : General : Databases and SQL :

General: Databases and SQL: MySQL FullText: Edit Log

Here is the list of edits for this post

Jun 21, 2002, 6:09 AM

Paul

Veteran (19537 posts)

Jun 21, 2002, 6:09 AM

MySQL FullText

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? Pirate

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

Have I lost my mind yet again?

(I'm thinking of resorting to LIKE)

Last edited by:

Paul: Jun 21, 2002, 6:10 AM

Edit Log:

Post edited by Paul Post edited by Paul (Veteran) on Jun 21, 2002, 6:09 AM
Post edited by Paul Post edited by Paul (Veteran) on Jun 21, 2002, 6:10 AM
Post edited by Paul Post edited by Paul (Veteran) on Jun 21, 2002, 6:10 AM

Gossamer Threads is a Vancouver-based company with over 28 years experience in web technology. From development to hosting, we partner with leading organizations around the globe and help to build their web presences, strategies and infrastructures.

Let’s talk: 1-877-715-7676