CollectionFind::groupBy
PHP function
Edit on GitHub ✎
Set grouping criteria
Description
mysql_xdevapi\CollectionFind::groupBy(string $sort_expr): mysql_xdevapi\CollectionFind
This function can be used to group the result set by one or more columns. It is often used with aggregate functions such as COUNT, MAX, MIN, SUM etc.
Parameters
sort_exprThe column or columns that have to be used for the group operation, this can either be a single string or an array of string arguments, one for each column.
Return Values
A CollectionFind object that can be used for further processing.
Examples
mysql_xdevapi\CollectionFind::groupBy() example
php
<?php
// Assuming $coll is a valid Collection object
// Extract all the documents from the Collection and group the results by the 'name' field
$res = $coll->find()->groupBy('name')->execute();
?>