CollectionFind::sort

(No version information available, might only be in Git)

CollectionFind::sort — Set the sorting criteria

说明

public mysql_xdevapi\CollectionFind mysql_xdevapi\CollectionFind::sort ( string $sort_expr )

Sort the result set by the field selected in the sort_expr argument. The allowed orders are ASC (Ascending) or DESC (Descending). This operation is equivalent to the 'ORDER BY' SQL operation and it follows the same set of rules.

参数

sort_expr: One or more sorting expressions can be provided. The evaluation is from left to right, and each expression is separated by a comma.

返回值

A CollectionFind object that can be used to execute the command, or to add additional operations.

范例

Example #1 mysql_xdevapi\CollectionFind::sort() example


<?php
//Assuming $coll is a valid Collection object.

// Find all the documents and sort them by 'age' in descending order, then sort again
// the result by 'job' in descending order and at the end by 'num' in ascending order
$res = $coll->find()->sort('age desc','job desc','num asc')->execute();

?>