Hello everyone!
I am trying to "translate" a mysql query to sphinx. The complicated
part is the ORDER BY clause. It is as follows:
ORDER BY qualified DESC,
if( user_score, if(( user_score=0 AND (user_title_en!=''
OR user_title!='')),-1,0),0),
if( user_pref, if( user_privilegies=0 , -1, 0), 0),
if( qualified, to_days(exam_date), -
(to_days(signup_date))),
user_name
Please, could anyone tell me if it is possible to sort results like
this in sphinx. I am searching for answers almost a week now and the
only think I found is information about "SPH_SORT_EXPR mode". But I
can't understand exactly how it works so I can chain all the "IF"
statements.
10x in advance!!
--
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/thinking-sphinx?hl=en.
