At 15:36 2002-11-10 -0800, you wrote:
>>From: "A. J. Maclean" <[EMAIL PROTECTED]>
>>
>>I have a query like this:
>>
>>SELECT * FROM bc_posts WHERE MATCH (post_city, post_location, post_details,
>>post_message) AGAINST ('webster');
>>
>>I get the results as follows:
>>
>>webster hall
>>webster
>>web
From: Jan Steinman [mailto:Jan@;Bytesmiths.com]
Sent: Sunday, November 10, 2002 6:37 PM
To: [EMAIL PROTECTED]
Subject: Re: one word fulltext matching problem...
Without ORDER BY clause, results of a SELECT are in arbitrary order. That's
just the way SQL works -- there is no "relevan
>From: "A. J. Maclean" <[EMAIL PROTECTED]>
>
>I have a query like this:
>
>SELECT * FROM bc_posts WHERE MATCH (post_city, post_location, post_details,
>post_message) AGAINST ('webster');
>
>I get the results as follows:
>
>webster hall
>webster
>webster hall club
>
>How come the exact match (i.e. "
Hi,
If 'webster' can be found in more than a half of the records from the
database, it is considered a stop word and it is ignored.
The solution is to force searching for that word by placing a '+' sign
before it like '+webster'
I guess this should be the problem, but if it is not the case, ...
