Re: Weighting searches

2007-03-14 Thread Nils Meyer
Hi John John Nichel wrote: The db is MySQL 4.1.20 and the column synonyms_misspellings has a FULLTEXT index on it (the db is set to index on 3 characters). Can anyone help me understand why it's not rating the one with the match three times higher than the one with the match twice, and point

Weighting searches

2007-03-13 Thread John Nichel
Hi list, I'm messing around with weighting my search results, and I've run into a weird quirk that I'm hoping someone here could help me understand. I have a query like such: SELECT xcart_products.product, xcart_product_meta.synonyms_misspellings, MATCH (xcart_produ