MySQL - Select results and order by relevance

match-against.sql

-- You should add a FULLTEXT index on each row you are searching
ALTER TABLE `user` ADD FULLTEXT INDEX (`first_name`);

--


SELECT *, (
	(1.2 * (MATCH(title) AGAINST (:query IN BOOLEAN MODE))) + 
	(0.8 * (MATCH(description) AGAINST (:query IN BOOLEAN MODE))) + 
	(1.0 * (MATCH(tags) AGAINST (:query IN BOOLEAN MODE))) 
) AS relevance
FROM table
WHERE 
MATCH (title,description,tags) AGAINST (:query IN BOOLEAN MODE) 
ORDER BY relevance DESC 
LIMIT 0,5