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
webster hall club
How come
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
, ... sorry.
I've started learning MySQL only for 3 days.
Cheers.
Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]
- Original Message -
From: A. J. Maclean [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Sunday, November 10, 2002 1:16 PM
Subject: one word fulltext
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. webster) does not
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 relevance ranking