Page 1 of 1

Fulltext search

Posted: Mon May 01, 2006 4:16 am
by php3ch0
is there a way of stating which fields are more important in a fulltext mysql search.

This is my code:

Code: Select all

SELECT *, MATCH(name, about, keywords) AGAINST ('$search' IN BOOLEAN MODE) AS relevance FROM bl_cat WHERE MATCH(name, about, keywords) AGAINST ('$search' IN BOOLEAN MODE) ORDER BY relevance ASC
Please help

Posted: Mon May 01, 2006 7:09 am
by feyd
Each field in the full text key are of equal value so no, not unless you break them apart.