Re: query the data of a fulltext index directly from index?

[Sergei Golubchik]

Hi!

On Feb 02, Alexander Bauer wrote:
> Hello,
> 
> is there any way to get the fulltext index contents directly? I'm looking
> for a way to list all indexed words from a column to provide a filter
> selection.
> 
> How can I access the index data without walking through all table rows, get
> the column and tokenize and collect words?

Use the ft_dump utility program that comes from MySQL source
distribution.
 
Regards,
Sergei

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <serg@stripped>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Senior Software Developer
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
       <___/  www.mysql.com