php8.5
Home/ Manual/ mysql_xdevapi / collectionmodify/ CollectionModify::sort

CollectionModify::sort

PHP function Edit on GitHub ✎

Set the sorting criteria

Description

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

Sorts 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.

Parameters

sort_expr

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

Return Values

CollectionModify object that can be used for further processing.

Examples

mysql_xdevapi\CollectionModify::sort() example

php
<?php

$res = $coll->modify('true')->sort('name desc', 'age asc')->limit(4)->set('Married', 'NO')->execute();

?>

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