Juozas devBlog

As websites grows, searches like “LIKE title ‘%search term%’” becomes unreliable. There are very good solutions like Sphinx, Lucene, etc, but not surprisingly, you can’t always have Sphinx installed (shared servers again) and other solutions should be chosen.
MySQL supports full-text indexing, but it doesn’t give a lot of control over actual index. Luckily, Zend [...]