How can I manipulate MySQL fulltext search relevance to make one field more ‘valuable’ than another?
Create three full text indexes a) one on the keyword column b) one on the content column c) one on both keyword and content column Then, your query: SELECT id, keyword, content, MATCH (keyword) AGAINST (‘watermelon’) AS rel1, MATCH (content) AGAINST (‘watermelon’) AS rel2 FROM table WHERE MATCH (keyword,content) AGAINST (‘watermelon’) ORDER BY (rel1*1.5)+(rel2) DESC … Read more