« A Tour of the MySQL Source Code | Main | MySQL Development Model »

April 20, 2005

Using and Extending Full Text in MySQL

Listening to Joe Stump talk about MySQL's full text indexing at MySQL 2005. Joe is at eNotes.com.

I looked at the full text search a year or so ago but it didn't feel like it was worth the switch from DBIx::FullTextSearch. The matching of MySQL's FULLTEXT didn't quite do the job, and weighting is important to us.

It appears that not much has changed in FULLTEXT since I last looked.

Joe has created a weighting workaround. He does multiple queries on different fields, and then takes the relevancy from each query and multiplies it by a factor based on the field that the match came from. Joe then combines the results and sorts by the calculated relevancy.

Joe indexes PDFs, Word docs and MP3s with special tools.

Posted by mike at April 20, 2005 7:54 PM