VIOLA!
As it turns out, the cnf file that I was shown was the cnf file on the OLD
server that we used when we had DB/Webserver combined on one server - that
conf was not updated for the new separate DB server.
Thanks muchly all, that change made the search work as expected!!!
Thanks for the star
Mike,
Mike Morton wrote:
OK - I am at a total loss here :)
We have added an addition fulltext field with the highest rating:
match(search_keywords) against ('vic*' IN BOOLEAN MODE) * 16
And verified that in that field, there is indeed a keyword "vic" - but still
- that result is not returned,
>
> 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 Schw
age-
> 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 w
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 "wo
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 Informatio