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.