Hi!
On Mar 05, Todd Burke wrote:
> Is there any way to iterate thru the keys in a fulltext index? This issue
> does not come up for other indexes since ORDER BY can achieve this:
>
> For example if table t is indexed on part_id
>
> SELECT DISTINCT part_id FROM t ORDER by part_id;
>
> will return all keys in index order
>
> Is there a way to do this for a fulltext index so that a query would
> return a list of all "words" in the index - this could be helpful
> to build dictionaries for ex.
No, but you can use an external utility myisam_ftdump to get this
functionality.
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
