As I mentioned before, you could use 'myisam_ftdump' to see the contents and word distribution of a MyISAM table's fulltext indexes. If you are very bold with source code, download the MySQL Source Code and lookup how fulltext indexes are populated.
You should be able to find that section of the code if you just look for the built-in stop word list, where it is used, and how words are inserted into the fulltext indexes once a word gets by the stop word list. Have Fun With It !!! ----- Original Message ----- From: Rares Vernica <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Sent: Tuesday, November 14, 2006 1:09:31 AM GMT-0500 US/Eastern Subject: Re: access full-text index I think the full-text index is an inverted index structure. So, it has all the words from the fields it indexes. For each word it has a list of record ID which have that word. What I am interested to get is this inverted index structure. I imagine it can be represented as 1-2 table(s). Can I do that? Is the structure accessible as a table? (Of course, I don't want to change it.) Thanks a lot, Ray Leandro Guimarães Faria Corcete DUTRA wrote: > On Wed, 08 Nov 2006 18:51:20 -0800, Rares Vernica wrote: > >> Is it possible to access the Full-Text Index structures from SQL? > > What do you mean exactly? SQL is not intended for physical structures. > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
