Database Search

[fatcodeguy]

Hi. I have a front end application for non-technical people which builds/edits queries and a search feature for data in the database. I need an algorithm "smarter" than just using SELECT ... FROM ... WHERE search_criteria LIKE '%search%' so that if that query returns nothing, data "similar" to the search criteria entered is returned (someone searches for packge, the database has new_package, algorithm returns that). Does this make sense ?? Thanks

 

[sedj]

You mean "fuzzy string matching" ? Have a look at Lucene project

http://jakarta.apache.org/lucene/docs/