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 them like this:
mysql> SELECT first_name,last_name FROM names_table WHERE MATCH(first_name,last_name) AGAINST ('+wilkinson* chris*' IN BOOLEAN MODE);
The problem is that for some reason the record with first_name=fran is displayed
first even though the score is lower than the record where first_name=christopher
mysql> 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); +-------------+-----------+-----------------+ | first_name | last_name | score | +-------------+-----------+-----------------+ | Fran | Wilkinson | 1 | | Christopher | Wilkinson | 1.3333333730698 | +-------------+-----------+-----------------+ 2 rows in set (0.01 sec)
Can somebody please explain why this is and how I can get Christopher to show up
before Fran! Thanks!
Add ORDER BY score DESC to the query.
-- Chris Wilkinson [EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]