List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 21 1999 9:10pm
Subject:Re: indexes on TEXT columns, keyword searching through text
View as plain text  
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/
Thread
indexes on TEXT columns, keyword searching through textTroy Grady22 Jun
  • Re: indexes on TEXT columns, keyword searching through textPaul DuBois22 Jun
  • Re: indexes on TEXT columns, keyword searching through textSasha Pachev22 Jun
    • RE: indexes on TEXT columns, keyword searching through textSteven Roussey22 Jun
      • C API webpagessimon22 Jun
        • RE: C API webpagesDouglas B. Jones22 Jun
        • Re: C API webpagesSasha Pachev22 Jun
      • Re: indexes on TEXT columns, keyword searching through textjonathan michaels23 Jun
Re: indexes on TEXT columns, keyword searching through textPhilip Hallstrom23 Jun
Re: indexes on TEXT columns, keyword searching through textTroy Grady24 Jun