I want to make one column more valuable than others like it's been done in query bellow.[This example ][1] shows that only one fulltext index is needed And [this answer][2]suggests that three fulltext indexes are needed to do the same. Here is the queries from the first link: ALTER TABLE products ADD FULLTEXT(title, sdescription, ldescription) SELECT *, MATCH(`title`) AGAINST ('+iphone +case +4s' IN BOOLEAN MODE) * 10 as rel1, MATCH(`sdescription`) AGAINST ('+iphone +case +4s' IN BOOLEAN MODE) * 3 as rel2, MATCH(`ldescription`) AGAINST ('+iphone +case +4s' IN BOOLEAN MODE) as rel3, FROM products WHERE MATCH (title, sdescription, ldescription) AGAINST ('+iphone +case +4s' IN BOOLEAN MODE) ORDER BY (rel1)+(rel2)+(rel3) DESC; I'm confused how many indexes are needed for that, one or three? I asked this question on stackoverflow but not answer yet. [1]: http://www.vionblog.com/mysql-full-text-search-with-multiple-words/ [2]: http://stackoverflow.com/questions/547542/how-can-i-manipulate-mysql-fulltext-search-relevance-to-make-one-field-more-val/600915#600915