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. "
PROTECTED]>
Sent: Sunday, November 10, 2002 1:16 PM
Subject: one word fulltext matching problem...
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
w
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. "webster") does not get a higher relevance?
I remember se
