Chris,
I should have added that the explanation is that the full text query does
not automatically sort on the score when boolean mode is selected.
Andy
> -Original Message-
> From: Chris Wilkinson [mailto:[EMAIL PROTECTED]
> Sent: 03 June 2003 13:12
> To: [EMAIL PROTECTED]
> Subject: fu
Chris,
You're nearly there - the way to do it is:
SELECT first_name,last_name,MATCH(first_name,last_name) AGAINST
('+wilkinson* chris*' IN BOOLEAN MODE) AS score FROM names_table WHERE
MATCH(first_name,last_name) AGAINST ('+wilkinson* chris*' IN
BOOLEAN MODE) ORDER BY score DESC;
The db engine w
At 13:11 +0100 6/3/03, Chris Wilkinson wrote:
can anybody explain this to me please! I search am searching
through a database
with first name and last names. BTW I use mysql 4.0.13 on RedHat Linux 9.0 in
case that matters. I created a fulltext search on both fields
together so I can
search the
User ORDER BY First Name
Chris Wilkinson wrote:
can anybody explain this to me please! I search am searching through a database
with first name and last names. BTW I use mysql 4.0.13 on RedHat Linux 9.0 in
case that matters. I created a fulltext search on both fields together so I can
search t
