Mike:
:) I wish! Free ham for everyone!
I had already changed the min length to 2 actually - so that is not the
affecting factor...
It is more of an issue to prioritizing fields for relevance, and whether it
is possible to do this within a fulltext query, or whether it needs to be
done through multiple queries, and then "outside" php processing of those
query results....
On 1/31/07 4:43 PM, "mos" <mos99@stripped> wrote:
> Mike,
> It's likely because MySQL fulltext index defaults to a word length
> of 4 characters or more. So "Ham" probably is not being indexed. You will
> need to change the minimum word length. See
> http://dev.mysql.com/doc/refman/5.0/en/fulltext-fine-tuning.html
>
> Mike
> (P.S. Send me a free ham while you're at it.<g>)
>
>
> At 02:02 PM 1/31/2007, Mike Morton wrote:
>> Does anyone have any suggestions on how to solve the result weighting
>> problem? I have a client whose search results are becoming more and more
>> important, and the relevance demands on the results are not entirely
>> satisfactory...
>>
>> The fields that are searched are code, name, small description and large
>> description, and are ranked in relevance in that order.
>>
>> For example, a product with the name: "Bone-In Serrano Ham" should ALWAYS
>> outweigh the product with the name of "Boneless Jamon Iberico", even if the
>> Jamon Iberico has the word "ham" in the description 20 times more than the
>> Serrano product...
>>
>> The query that is being run is:
>> select *,match(code,name,small_desc,large_desc) against ('ham*') as score
>> from products where active='y' and site like '%,1,%' and
>> match(code,name,small_desc,large_desc) against ('ham*' IN BOOLEAN MODE)
>> order by score desc
>>
>> It returns some good relevant matches, but then in the middle of products
>> names with "ham" in them, it returns one without....
>>
>> Does this require a complete logic switch, or is there a way to build a
>> query to do this?
>>
>> Obviously the actual build of the query is more complex, and there are other
>> rules that need to be applied to the user submitted query, but this is the
>> basics...
>>
>> If there is a Fulltext search relevance expert out there in list land, I am
>> at my wits end trying to make the results the most relevant that they can be
>> - I am willing to work closely with (pay) someone with the knowledge and
>> expertise to assist in this. (using PHP)
>>
>> TIA - hope someone can help!
>>
>> --
>> Cheers
>>
>> Mike Morton
>>
>> ****************************************************
>> *
>> * Tel: 905-465-1263
>> * Email: mike@stripped
>> *
>> ****************************************************
>>
>>
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
--
Cheers
Mike Morton
****************************************************
*
* Tel: 905-465-1263
* Email: mike@stripped
*
****************************************************
