Sorting results in sphinx?

Is there an easy way to sort开发者_运维百科 sphinx results?

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

---

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

---

Do you mean beyond the order by clause?

select *
from mytable 
order by 1