Hi!
On Nov 13, Rares Vernica wrote:
> 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 IDs which have that word.
>
> 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? Is the structure accessible in any way? (Of
> course, I don't want to change it.)
You can do it, but not from SQL, unfortunately.
There's a separate utility myisam_ftdump that allows you to examine
fulltext index, this functionality wasn't integrated into the server
yet.
> Sergei Golubchik wrote:
> >On Nov 10, Rares Vernica wrote:
> >>
> >>Is it possible to access the Full-Text Index structures from SQL?
> >
> >Depends on what structures you want to access and how.
> >But generally - no.
> >
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <serg@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Kerpen, Germany
<___/ www.mysql.com
