MySQL Forums
Forum List  »  Full-Text Search

FullText query
Posted by: Emy Webmaster
Date: November 16, 2006 03:15AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
FullText query
3127
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.