Documentation Home
Download this Manual
PDF (US Ltr) - 2.4Mb
PDF (A4) - 2.4Mb
HTML Download (TGZ) - 250.9Kb
HTML Download (Zip) - 258.4Kb

MySQL PHP API  /  ...  /  CrudOperationSortable::sort

5.15.1 CrudOperationSortable::sort

Copyright 1997-2019 the PHP Documentation Group.

  • CrudOperationSortable::sort

    Sort results


abstract public mysql_xdevapi\CrudOperationSortable mysql_xdevapi\CrudOperationSortable::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.


This function is currently not documented; only its argument list is available.



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

Return Values

A CrudOperationSortable object.


Example 5.72 mysql_xdevapi\CrudOperationSortable::sort example


$res = $coll->find('job like \'Cavia\'')->sort('age desc', '_id desc')->execute();


User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.