MySQL Forums
Forum List  »  Full-Text Search

Accessing the full-text index from SQL
Posted by: walter_tom
Date: January 11, 2006 09:05PM

Hi, I'm wondering if it is possible to work with the contents of the full-text index using SQL queries.

I've seen the other posts in this thread that mention the myisam_ftdump utility, but rather than writing the index to a file, I'd like to be able to do queries against it, something like this

SELECT weight FROM sometable.fulltextindex WHERE word = 'someword'

Any ideas?

Why you ask? Well I'm trying to figure out text-clustering and it occured to me that the full text index already stores a bunch of info that could be helpful for this purpose.

Options: ReplyQuote

Written By
Accessing the full-text index from SQL
January 11, 2006 09:05PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.