Basically, I got the same problem as this guy but I also need relevancy: http://stackoverflow.com/questions/1878899/php-smart-search-engine-to-search-mysql-tables-adviceBut, I can't use Sphinx or Lucene (shared hosting)...I can use LIKE but that has not relevancy so does anyone know a good PHP class that does create relevancy?So I need something that fits this bill:
- Result relevancy value
- Match part of words, i.e. "LIKE %searchterm%"
- Search multiple database columns
- Can't use things like Sphinx or Lucene, no supported by my shared hosting...