Good examples of a site search with relevance across multiple tables (php/mysql)

Question

I am trying to build a site-wide search with relevance, the site has around 5 tables that needs to be searched could anyone provide some assistance (or links) that will help to achieve this? (Never done this before and I don't really want to use a google plugin that will show the google image all over it.

Thanks in advance

Answer 1

Look at lucene search its very powerfull and supports multiple kinds of data from multiple places.