Edit Report a Bug

    CollectionFind::having

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

    CollectionFind::having — Set condition for aggregate functions

    Description

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

    This function can be used after the 'field' operation in order to make a selection on the documents to extract.

    Liste de paramètres

    sort_expr

    This must be a valid SQL expression, the use of aggreate functions is allowed

    Valeurs de retour

    CollectionFind object that can be used for further processing

    Exemples

    Exemple #1 mysql_xdevapi\CollectionFind::having() example

    <?php

    //Assuming $coll is a valid Collection object

    //Find all the documents for which the 'age' is greather than 40,
    //Only the columns 'name' and 'age' are returned in the Result object
    $res = $coll->find()->fields(['name','age'])->having('age > 40')->execute();

    ?>
    add a note add a note

    User Contributed Notes

    There are no user contributed notes for this page.
    To Top