Fulltext search

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
php3ch0
Forum Contributor
Posts: 212
Joined: Sun Nov 13, 2005 7:35 am
Location: Folkestone, Kent, UK

Fulltext search

Post 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
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Each field in the full text key are of equal value so no, not unless you break them apart.
Post Reply