Searching for content in mysql was always an issue. The implementation that I was aware of ranged from the very basic “select * from xyz where name like % " to using indexing and culling out statistically significant result. The implementation itself took quite sometime.

Recently I stumbled upon Sphinx, an open source full text search engine. It is very very useful for any app which includes showing users some sort of search results based on text mining.

Link : Sphinx - Free open-source SQL full-text search engine