List words in fulltext index

Hi all,

Is there a way to get a list of all the words in a specified fulltext
index? I'd like to be able to query the index for instance to get all
the words starting with 'a' or 'aa' etc.

I'm familiar with the myisam_ft_dump tool by the way, but I'd like to
query the index from a php script, so the tool isn't very convenient in
that case. Also it's giving me trouble with diacriticals (ë,é etc.).

Hope someone knows of a better way.
Thanks.

Kind regards,
Ruben.

Re: List words in fulltext index

Ruben van Engelenburg wrote:
> Hi all,
>
> Is there a way to get a list of all the words in a specified fulltext
> index? I'd like to be able to query the index for instance to get all
> the words starting with 'a' or 'aa' etc.
>
> I'm familiar with the myisam_ft_dump tool by the way, but I'd like to
> query the index from a php script, so the tool isn't very convenient in
> that case. Also it's giving me trouble with diacriticals (ë,é etc.).
>
> Hope someone knows of a better way.
> Thanks.


I take this isn't possible, since there are no replies?

Regards,
Ruben.

Re: List words in fulltext index

Ruben van Engelenburg wrote:
>> Is there a way to get a list of all the words in a specified fulltext
>> index? ...
> I take this isn't possible, since there are no replies?

I don't know of any way to query the contents of the FT index. Even the
"internals" page on FT search mentions only the myisam_ft_dump tool.
http://dev.mysql.com/doc/internals/en/full-text-search.html

You may have to call out to the shell in your PHP app, run
myisam_ft_dump, and parse the string returned.
http://www.php.net/manual/en/function.shell-exec.php

Regards,
Bill K.

Re: List words in fulltext index

Bill Karwin wrote:

> I don't know of any way to query the contents of the FT index. Even the
> "internals" page on FT search mentions only the myisam_ft_dump tool.
> http://dev.mysql.com/doc/internals/en/full-text-search.html
>
> You may have to call out to the shell in your PHP app, run
> myisam_ft_dump, and parse the string returned.
> http://www.php.net/manual/en/function.shell-exec.php

Hi there Bill,

Thanks for your reply. Yes using myisam_ft_dump from the php app was the
plan. I just thought there might be a way to query an ft index directly.
But this will do for now. Thanks.

Regards,
Ruben.