Sorting results in sphinx?

Question

Is there an easy way to sort sphinx results?

Recently posted (by dates) Highest paid (highest value)

Answer 1

Do you mean beyond the order by clause?

select *
from mytable 
order by 1

Answer 2

Sphinx has sorting-modes: http://sphinxsearch.com/docs/current.html#sorting-modes, what you need is SPH_SORT_ATTR_DESC mode & SPH_SORT_ATTR_ASC mode