Hosting Provided By

Re: Fulltext Relevancy not returning anticipated results?

From: Mike Morton <mike(at)webtraxx.com>
Date: Tue Oct 30 2007 - 09:55:38 EDT

Jerry:

Sorry - I should have mentioned in my previous email that we have changed that min. word length to 2 in the config already, as we have MANY 3 letter searches... ;)

Any other suggestions?

On 10/30/07 9:12 AM, "Jerry Schwartz" <jschwartz@the-infoshop.com> wrote:

> By default, MySQL ignores any "word" with less than four characters when
> doing full text searches. You can change this in my.conf, the setting should
> be obvious.
> 
> I had to do this so that customers could find inventory items that were red.
> 
> Regards,
> 
> Jerry Schwartz
> The Infoshop by Global Information Incorporated
> 195 Farmington Ave.
> Farmington, CT 06032
> 
> 860.674.8796 / FAX: 860.674.8341
> 
> www.the-infoshop.com
> www.giiexpress.com
> www.etudes-marche.com
>

>> -----Original Message-----
>> From: Mike Morton [mailto:mike@webtraxx.com]
>> Sent: Monday, October 29, 2007 5:39 PM
>> To: mysql@lists.mysql.com
>> Subject: Fulltext Relevancy not returning anticipated results?
>>
>> I have a database of products, doing a search on them trying to achieve
>> a
>> modicum of relevancy, but am getting a strange result on some returned
>> rows:
>>
>> QUERY:
>> select *,match(code) against ('vic*' IN BOOLEAN MODE) * 8 + match(name)
>> against ('vic*' IN BOOLEAN MODE) * 4 + match(small_desc) against
>> ('vic*' IN
>> BOOLEAN MODE) * 2 + match(large_desc) against ('vic*' IN BOOLEAN MODE)
>> as
>> score from products where active='y' and site like '%,1,%' and
>> match(code,name,small_desc,large_desc) against ('vic*' IN BOOLEAN MODE)
>> order by score desc
>>
>> I get returned 6 rows from the product database. The strange thing is,
>> there is a product (at least one that is known about), with the name:
>> "Salchichon de Vic" that is NOT being returned as a result.
>>
>> When I break out the scores, I get a match on the first three products
>> returned for the titles:
>>
>> 6-Pack Vichy Catalan Sparkling Spring Water
>> 2-Pack Vichy Catalan Mineral Water
>> San Vicente - Tempranillo 2001
>>
>> And the other three products have a match in the large_desc.
>>
>> What is confusing me is why I am not getting any match on the titles
>> for the
>> "Salchichon de Vic" - which by my thought process should be the most
>> relevant of all returns?
>>
>> Any thoughts on this? The term "vic" used in this case is the search
>> string
>> submitted by the user.
>>
>> You can see the search in action at
>> http://www.tienda.com/support/search.html
>>
>> --
>> Cheers
>>
>> Mike Morton
>>
>> ****************************************************
>> *
>> * Tel: 905-465-1263
>> * Email: mike@webtraxx.com
>> *
>> ****************************************************
>>
>>
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql?unsub=jschwartz@the-
>> infoshop.com

> 
> 
> 
>

-- 
Cheers

Mike Morton

****************************************************
*
* Tel: 905-465-1263
* Email: mike@webtraxx.com
*
****************************************************




-- 
MySQL General Mailing List
For list archives: 
http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/mysql?unsub=lists@pantek.com

Received on Tue Oct 30 09:56:38 2007

This message: [ Message body ]
Next message: Augusto Bott: "Re: replication and ibdata file size"
Previous message: Jerry Schwartz: "RE: Fulltext Relevancy not returning anticipated results?"
In reply to: Jerry Schwartz: "RE: Fulltext Relevancy not returning anticipated results?"
Next in thread: Jerry Schwartz: "RE: Fulltext Relevancy not returning anticipated results?"
Reply: Jerry Schwartz: "RE: Fulltext Relevancy not returning anticipated results?"

Contemporary messages sorted: [ By Date ] [ By Thread ] [ By Subject ] [ By Author ] [ By messages with attachments ]

This archive was generated by hypermail 2.1.8 : Thu Jul 03 2008 - 08:43:26 EDT