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

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.