From: Dan Nelson
Date: February 2 2004 4:24pm
Subject: Re: query the data of a fulltext index directly from index?
List-Archive: http://lists.mysql.com/mysql/158844
Message-Id: <20040202162430.GB25030@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Feb 02), Alexander Bauer said:
> 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?

Try the ft_dump command; it can dump the word and frequency stats from
fulltext indexes.

-- 
	Dan Nelson
	dnelson@stripped