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
