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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] >> * >> **************************************************** >> >> >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Cheers Mike Morton **************************************************** * * Tel: 905-465-1263 * Email: [EMAIL PROTECTED] * **************************************************** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]