FullText query
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:
field1
field3
field2
How do i do?
Thanks
Emy
Subject
Views
Written By
Posted
FullText query
3152
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.