I’m building a web crawler which collects crawled results into MySQL table.
There are Five Main Columns:
URL, TITLE, DESCRIPTION, KEYWORDS, BODY.
Currently I’m using
FULLTEXT search function of MySQL as follows:
SELECT URL,title, description, MATCH (description, keywords, title, URL) AGAINST ('$keyword' in boolean mode) AS score FROM record WHERE MATCH (description, keywords, title, URL) AGAINST ('$keyword' in boolean mode) order by score desc;";
But it is not giving me good results. Consider the following image.
Here, the facebook is at 23rd position on searching
Can i prioritize the search based upon the coloumn name? For example, I want the query to give maximum priority to
keywords.. and finally
Any suggestions ?