Sphinx排序模式，按升序排序，忽略零

Question

I'm using Sphinx with SPH_SORT_EXTENDED.

$s->SetSortMode ( SPH_SORT_EXTENDED, 'webvalue asc' );
$s->SetRankingMode ( SPH_RANK_SPH04 );

$s->SetLimits($page, 8);

This is working fine, however my database contains rows where webvalue is 0.00 (webvalue is DECIMAL field type).

What I'd like to do is order by webvalue ascending, but essentially ignore zero values so they appear at the end of the results.

Answer 1

Already answered here, on the sphinxsearch forum: http://sphinxsearch.com/forum/view.html?id=12236