Hibernate Search – Getting Started
Once your dynamic site has gone bigger, data in relational database has grown, there is always a need for searching the contents. SQL queries with like ‘%…%’ are useful. But to do multiple columns / table searching, we’ll need to have big SQL queries with different conditions, ANDed and ORed. Such searching is not realistic and can not be maintained and extended easily.
For Hibernate users, Hibernate search helps searching rows from database. Without writing any complex SQL queries, you can search multiple columns and get related objects from db.
In our site Skill-Guru , you will notice a search box on the right hand side. We have enabled the search on few tables and columns initially. Currently it will search for the tests , description and keywords for the input keyword.

