Try to delete 'in boolean mode' Santino
At 12:42 -0700 5-10-2004, Ed Lazor wrote:
> -----Original Message-----Try this:
select column1, match(column1) against ('+orange -fruit' IN BOOLEAN MODE) as score from some_table where match(column1) against('+orange -fruit' IN BOOLEAN MODE) order by score desc
this way you have your results ordered by relevance, and you also get the relevance value in the result if you want to.
Looks interesting. I'm not sure if it's working. I'm looking at the results of running the query manually against the database and every record in the result set has a score value of 1. Is that the way it should be?
-Ed
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
