Hello all-
I have a question on searching via fulltext.
I have the following SQL statement:
var('SQLResultsID') = 'select *, MATCH
(product_id,product_name,product_desc) AGAINST(' + $sqlKeywordSearch + ') AS
SCORE from products WHERE MATCH (product_id,product_name,product_desc)
AGAINST(' + $sqlKeywordSearchB + ' IN BOOLEAN MODE) AND active NOT LIKE
%no% ORDER BY score DESC
First off, the variable $sqlKeywordSearch contains the search keywords
separated by spaces. The second variable, $sqlKeywordSearchB, has keywords
separated by spaces but also adds a “+ sign to the beginning of each keyword
to do the Boolean search and match all the keywords in the search.
question #1 - Is this the best way to do a boolean search but also return a
usable “score”? The search is doing what I expect it to do so no problem there.
Here’s my main question: I want to be able to “boost the rankings(score) of
the results based on the fields. Anything that matches on the product_id field
I would like to get a higher ranking, then the product_name field next, then
the product_desc last (obviously, if something matches in the product_id field
it is of greater importance than if it matches in the product_description
field). I know I can boost, or adjust, the score to the keywords if I want
but is there a way to add to the search score rankings based on the field
searched?
as always, Thank everyone for any help!
James
James Sheffer j...@higherpowered.com
Lasso Developerhttp://www.higherpowered.com
phone: 469-256-0268
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql