I am building a PHP Search Engine and am using the LIKE operator. The problem is, is that there is no relevancy, all it does is just display everything that's in the table. I need to make my search engine rank results based off of keyword occurence.
Look in here: http://dev.mysql.com/doc/refman/4.1/en/fulltext-search.html
