MySQL Forums
Forum List  »  Full-Text Search

Access to words captured in the Full Text Index
Posted by: Gordon Bruce
Date: March 14, 2007 01:47PM

Is it possible to extract the words from the index that apply to a specific document.

i.e. I have a table as defined below. I add a document to the table and then I want to know what words in the index "docu_Body_IDF" reference the document just added.

CREATE TABLE documents (
docu_Path varchar(200) NOT NULL DEFAULT '',
docu_ID int(5) unsigned NOT NULL AUTO_INCREMENT,
docu_Body text,
docu_Type varchar(20) NOT NULL default '',
docu_Timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (docu_Path,docu_ID),
KEY docu_Body_IDX (docu_Body(250)),
KEY docu_Type_IDX (docu_Type),
FULLTEXT KEY docu_Body_IDF (docu_Body),
FULLTEXT KEY docu_Path_IDF (docu_Path)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Options: ReplyQuote


Subject
Views
Written By
Posted
Access to words captured in the Full Text Index
3110
March 14, 2007 01:47PM


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.