> -----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]
