Re: fulltext searches

Hi Octavian, Yes indeed... "IT" is a stop word... despite being the acronym for "Information Technology"... *It* is a third-person neuter pronounin the English language. You can make it "IT" a normal word by excluding it from the build-in stop word list

Re: Fulltext searches

Thanx Chris. That was it. To save space, I went ahead and dropped the two separate indexes because they were no longer needed. The only fulltext search performed on this database includes both fields. Thanx again, Robb On Fri, 21 May 2004 13:42:21 -0700, Chris wrote: > What query are you using t

Re: Fulltext searches

What query are you using to search? With the FullText indexes you have only two match options are possible: MATCH(specs) AGAINST . . . and MATCH(manufacturer) AGAINST . . . If you're trying to search both at the same time you need a FULLTEXT index of (specs,manufacturer) Chris Robb Kerr wrote: G

Re: Fulltext searches question

At 13:00 -0500 7/19/03, Wesley Hobbie wrote: I am running MySQL 4.0.12 on Windows XP. I am trying to create a library database and have a table named "cardCatalog" in the "library" database. The cardCatalog has the following fields: callNumber (varchar(60)), title (varchar(255)), author (varchar(2

Re: FullText Searches

Hi! On Oct 02, Thomas Deliduka wrote: > For MySQL Full-text Searches and indexes. Do these indexes take up a lot of > disk space? > > Any information on this out there as to how much on average? In default configuration (that is without changing myisam/ftdefs.h) index can be as big as original