A GOOD SEARCH TECHNIQUE

A fine way to search from more than one column from the DB.
Even, all the join conditions can easily be provided...
Check this out ...

TextSearch