Fulltext search
Posted: Mon May 01, 2006 4:16 am
is there a way of stating which fields are more important in a fulltext mysql search.
This is my code:
Please help
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