How to use Lucene with MySQL?
Under Ubuntu 11.04 I have installed MySQL Server, MySQL Workbench and Lucene libraries form repository. On MySQL Workbench I have created new schema with one table. The columns on the table are:
1. Primary key "ID" - not null with automatic incrementation
2. "article_author" - VARCHAR(40)
3. "article_topic" - VARCHAR(150)
4. "article_body" - TEXT
To the columns with author, topic and body I have added Full-text Index.
The question is: what I have to do now to search in this table using Lucene? Is there such a possibility?