Re: FULLTEXT search and ORDER BY

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

FULLTEXT search and ORDER BY

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