php8.5
Home/ Manual/ mysql_xdevapi / crudoperationsortable/ CrudOperationSortable::sort

CrudOperationSortable::sort

PHP function Edit on GitHub ✎

Sort results

Description

mysql_xdevapi\CrudOperationSortable::sort(string $sort_expr): mysql_xdevapi\CrudOperationSortable

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.

Func

Parameters

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.

Return Values

A CrudOperationSortable object.

Examples

mysql_xdevapi\CrudOperationSortable::sort() example

php
<?php

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

?>

Source: reference/mysql_xdevapi/mysql_xdevapi/crudoperationsortable/sort.xml · from the official PHP manual (php/doc-en)