Hi all.
I have a fulltext index on a table.
If I have the following fields:
field1,field2,field3,field4
Field4 being the fulltext field.
I have the following indices:
index1->field1,field2,field3
index2->fulltext field4
If I do a select:
select * from table where match(index2)
against ('word1 word2' in boolean mode);
I get a very fast result.
Essentially I want to do the following:
If I do a select field1,field2,field3 from table
where field1='something'
and field2='something_else'
and field3='something_more'
and match(field4) against ('word1 word2' in boolean mode)
order by field1,field2,field3
I can't seem to get it right that the query can return
quickly, as it does a table scan to sort the table,
which takes forever.
How do I get a fulltext search to be able to sort according
to a different field ???
Thanks for all assistance :-)
Regards,
Herbert
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
