Hello,

I have a MySQL table with these fields (and other irrelevant ones):

Field   Type            Description
num     MEDIUMINT       unique identifier for each row
message MEDIUMTEXT      the text of a message

Given a search string, I would like to be able to get the list of "num"
fields for the messages that match the search string (the messages are
plain text, not HTML). I would have used MySQL's built-in full text
indexing, but it doesn't support phrase searching so I'm looking into
using htdig/mifluz.

If I am not mistaken, the Search::Mifluz perl module will allow me to
execute the search queries.

However, I am confused as to how I can build the inverted indexes in the
first place. Do I need to write a C++ program to parse the "message"
fields from the database, inserting each word that it finds individually,
or is there some code I can download somewhere that will do this to me? I
would think that the former (taking a plain text document and inserting it
into mifluz) is a common enough task that someone has already written code
for it.

Thanks,

-Philip Mak ([EMAIL PROTECTED])



_______________________________________________
htdig-general mailing list <[EMAIL PROTECTED]>
To unsubscribe, send a message to <[EMAIL PROTECTED]> with a 
subject of unsubscribe
FAQ: http://htdig.sourceforge.net/FAQ.html

Reply via email to