This can be easily done via DBSight

Article:		MySQL FULLTEXT Searching
Subject:		This can be easily done via DBSight
Date:		2007-03-28 17:27:22
From:		chrislusf

I just need 2 SQLs: select * from blog_entries select * from blog_categories where categoryID = ? Then I can use DBSight to create a Lucene based full text search. Please take a look at this http://wiki.dbsight.com/index.php?title=Create_Lucene_Database_Search_in_3_minutes You can create a full-text database search service, return results as HTML/XML/JSON. It uses the Lucene directly in java, but can be easily used with Ruby, PHP, or any existing database web applicatoins. You can easily index, re-index, incremental-index. It's also highly scalable and easily customizable. The best thing is, it's super easy. You can create a production-level search in 3 minutes.