Sorry, no. I hope someone else will be able to help. 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:[EMAIL PROTECTED] > Sent: Tuesday, October 30, 2007 9:56 AM > To: Jerry Schwartz; mysql@lists.mysql.com > Subject: Re: Fulltext Relevancy not returning anticipated results? > > 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" <[EMAIL PROTECTED]> > 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:[EMAIL PROTECTED] > >> 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: [EMAIL PROTECTED] > >> * > >> **************************************************** > >> > >> > >> > >> > >> -- > >> MySQL General Mailing List > >> For list archives: http://lists.mysql.com/mysql > >> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >> infoshop.com > > > > > > > > > > -- > 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]
