Re: FULLTEXT search and ORDER BY

2002-10-02 Thread Sergei Golubchik 

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

FULLTEXT search and ORDER BY

2002-10-01 Thread Grzegorz Paszka 

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.

How can I solve this problem and force mysql to do what I want ? :)

Regards.
-- 
Grzegorz

-
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