Re: Query the Index?

[Erik Rooijmans]

Hi Rick,

I'm sorry but I don't fully understand what you are saying.
Let say I have the following table:

id (autoincrement), article (mediumtext).

I create a full text index on the article column.
This index will take multiple words(since the article text contains a lot of text) from 1 row of the table.

using myisam_ftdump I can actually see the indexed words that.
So I'm looking for a possiblity to search through all indexed words.

If this is not possible directly then the solution might even be running a scheduled task dumping the index to a txt file and then import that into a seperate table, using the seperate table for the autocomplete.

Please advice,