Hi!
On Oct 01, Grzegorz Paszka wrote:
> Hi.
>
> I've such problem.
> Is "ORDER BY" works with MATCH AGAINST ?
> i.e.
> create table test ( id_test int11, message text);
>
> SELECT id_test, message FROM test WHERE WHERE MATCH (message) AGAINST
> ('example' IN BOOLEAN MODE) ORDER BY id_test
>
> For me in mysql 4.0.3beta this select doesn't work as I want. Results are still
> sorted by score from MATCH AGAINST phrase. I know that such order by breaks
> philosophy of MATCH AGAINST, but when I want sort results in different way I
> should be able to do this.
It's strange.
First, MATCH .. AGAINST ( ... IN BOOLEAN MODE) does not sort results by
relevance automatically.
Second, even without IN BOOLEAN MODE one can always use ORDER BY to
apply any sort order he wants - it is not against
"philosophy of MATCH AGAINST" in any way :)
Could you provide a repeatable test case ?
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
