Re: indexes on TEXT columns, keyword searching through text

[Paul DuBois]

At 3:57 PM -0500 6/21/99, Troy Grady wrote:
>Folks-
>
>We store a lot of text (multi-page resumes and notes) that is too big to fit
>in VARCHAR columns and we do a lot of keyword searches through these fields
>like, for example:  "find me every TEXT field that contains the word [...]
>and the word [...]"  With several thousand such fields -- and growing --
>clearly we need some kind of indexing going on.
>
>The MySQL manual indicates that the new default table type (MYISAM) in the
>upcoming release (3.23.0) will support indexes on TEXT and BLOB columns.
>Does anyone know if this means an index on the first N characters of a TEXT
>column or an index on every word of a TEXT column?

The former.

--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/