Hi, I have a problem :(
I have this query with fulltext fields:
select field1, fields2, fields3, field4, field_data, field6,
match(field1, field2, field3) against("word1 word2") as relevancy,
match(field1, field2, field3) against("word1 word2" in boolean mode) as wrdcount
from scheda where field8='1' and field9='0' and field10='1'
and field_data >= curdate() and field_data <> '0000-00-00' and
match(field1, field2, field3) against("word1 word2" in boolean mode) >= 0.2
order by wrdcount DESC,relevancy DESC limit 0,30;
This query is perfectly, but I MUST ORDER the results with this prority fields in match query:
How do i do?
November 16, 2006 03:15AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.