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.
Remi Mikalsen
E-Mail: [EMAIL PROTECTED]
URL: http://www.iMikalsen.com
On 5 Oct 2004 at 10:53, Ed Lazor wrote:
> Is there a way to have boolean fulltext searches and still have results
> automatically sorted in order of decreasing relevance?
>
> It would be nice to enter a search for
>
> +orange -fruit
>
> And have the results come back in order of decreasing relevance.
>
> Thanks,
>
> 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]
