Aplus Framework Docs

Having uses trait:short

Trait Having.

Methods

having() : static: Appends an "AND $column $operator ...$values" condition in the HAVING clause.
havingBetween() : static: Appends an "AND $column BETWEEN $min AND $max" condition in the HAVING clause.
havingEqual() : static: Appends an "AND $column = $value" condition in the HAVING clause.
havingGreaterThan() : static: Appends an "AND $column > $value" condition in the HAVING clause.
havingGreaterThanOrEqual() : static: Appends an "AND $column >= $value" condition in the HAVING clause.
havingIn() : static: Appends an "AND $column IN (...$values)" condition in the HAVING clause.
havingIsNotNull() : static: Appends an "AND $column IS NOT NULL" condition in the HAVING clause.
havingIsNull() : static: Appends an "AND $column IS NULL" condition in the HAVING clause.
havingLessThan() : static: Appends an "AND $column < $value" condition in the HAVING clause.
havingLessThanOrEqual() : static: Appends an "AND $column <= $value" condition in the HAVING clause.
havingLike() : static: Appends an "AND $column LIKE $value" condition in the HAVING clause.
havingNotBetween() : static: Appends an "AND $column NOT BETWEEN $min AND $max" condition in the HAVING clause.
havingNotEqual() : static: Appends an "AND $column != $value" condition in the HAVING clause.
havingNotIn() : static: Appends an "AND $column NOT IN (...$values)" condition in the HAVING clause.
havingNotLike() : static: Appends an "AND $column NOT LIKE" $value condition.
havingNullSafeEqual() : static: Appends an "AND $column <=> $value" condition in the HAVING clause.
orHaving() : static: Appends a "OR $column $operator ...$values" condition in the HAVING clause.
orHavingBetween() : static: Appends a "OR $column BETWEEN $min AND $max" condition in the HAVING clause.
orHavingEqual() : static: Appends a "OR $column = $value" condition in the HAVING clause.
orHavingGreaterThan() : static: Appends a "OR $column > $value" condition in the HAVING clause.
orHavingGreaterThanOrEqual() : static: Appends a "OR $column >= $value" condition in the HAVING clause.
orHavingIn() : static: Appends a "OR $column IN (...$values)" condition in the HAVING clause.
orHavingIsNotNull() : static: Appends a "OR $column IS NOT NULL" condition in the HAVING clause.
orHavingIsNull() : static: Appends a "OR $column IS NULL" condition in the HAVING clause.
orHavingLessThan() : static: Appends a "OR $column < $value" condition in the HAVING clause.
orHavingLessThanOrEqual() : static: Appends a "OR $column <= $value" condition in the HAVING clause.
orHavingLike() : static: Appends a "OR $column LIKE $value" condition in the HAVING clause.
orHavingNotBetween() : static: Appends a "OR $column NOT BETWEEN $min AND $max" condition in the HAVING clause.
orHavingNotEqual() : static: Appends a "OR $column != $value" condition in the HAVING clause.
orHavingNotIn() : static: Appends a "OR $column NOT IN (...$values)" condition in the HAVING clause.
orHavingNotLike() : static: Appends a "OR $column NOT LIKE $value" condition in the HAVING clause.
orHavingNullSafeEqual() : static: Appends a "OR $column <=> $value" condition in the HAVING clause.
orWhere() : static: Appends a "OR $column $operator ...$values" condition in the WHERE clause.
orWhereBetween() : static: Appends a "OR $column BETWEEN $min AND $max" condition in the WHERE clause.
orWhereEqual() : static: Appends a "OR $column = $value" condition in the WHERE clause.
orWhereGreaterThan() : static: Appends a "OR $column > $value" condition in the WHERE clause.
orWhereGreaterThanOrEqual() : static: Appends a "OR $column >= $value" condition in the WHERE clause.
orWhereIn() : static: Appends a "OR $column IN (...$values)" condition in the WHERE clause.
orWhereIsNotNull() : static: Appends a "OR $column IS NOT NULL" condition in the WHERE clause.
orWhereIsNull() : static: Appends a "OR $column IS NULL" condition in the WHERE clause.
orWhereLessThan() : static: Appends a "OR $column < $value" condition in the WHERE clause.
orWhereLessThanOrEqual() : static: Appends a "OR $column <= $value" condition in the WHERE clause.
orWhereLike() : static: Appends a "OR $column LIKE $value" condition in the WHERE clause.
orWhereMatch() : static: Appends a "OR MATCH (...$columns) AGAINST ($against IN NATURAL LANGUAGE MODE)" fulltext searching in the WHERE clause.
orWhereMatchInBooleanMode() : static: Appends a "OR MATCH (...$columns) AGAINST ($against IN BOOLEAN MODE)" fulltext searching in the WHERE clause.
orWhereMatchWithQueryExpansion() : static: Appends a "OR MATCH (...$columns) AGAINST ($against WITH QUERY EXPANSION)" fulltext searching in the WHERE clause.
orWhereNotBetween() : static: Appends a "OR $column NOT BETWEEN $min AND $max" condition in the WHERE clause.
orWhereNotEqual() : static: Appends a "OR $column != $value" condition in the WHERE clause.
orWhereNotIn() : static: Appends a "OR $column NOT IN (...$values)" condition in the WHERE clause.
orWhereNotLike() : static: Appends a "OR $column NOT LIKE $value" condition in the WHERE clause.
orWhereNullSafeEqual() : static: Appends a "OR $column <=> $value" condition in the WHERE clause.
where() : static: Appends an "AND $column $operator ...$values" condition in the WHERE clause.
whereBetween() : static: Appends an "AND $column BETWEEN $min AND $max" condition in the WHERE clause.
whereEqual() : static: Appends an "AND $column = $value" condition in the WHERE clause.
whereGreaterThan() : static: Appends an "AND $column > $value" condition in the WHERE clause.
whereGreaterThanOrEqual() : static: Appends an "AND $column >= $value" condition in the WHERE clause.
whereIn() : static: Appends an "AND $column IN (...$values)" condition in the WHERE clause.
whereIsNotNull() : static: Appends an "AND $column IS NOT NULL" condition in the WHERE clause.
whereIsNull() : static: Appends an "AND $column IS NULL" condition in the WHERE clause.
whereLessThan() : static: Appends an "AND $column < $value" condition in the WHERE clause.
whereLessThanOrEqual() : static: Appends an "AND $column <= $value" condition in the WHERE clause.
whereLike() : static: Appends an "AND $column LIKE $value" condition in the WHERE clause.
whereMatch() : static: Appends an "AND MATCH (...$columns) AGAINST ($against IN NATURAL LANGUAGE MODE)" fulltext searching in the WHERE clause.
whereMatchInBooleanMode() : static: Appends an "AND MATCH (...$columns) AGAINST ($against IN BOOLEAN MODE)" fulltext searching in the WHERE clause.
whereMatchWithQueryExpansion() : static: Appends an "AND MATCH (...$columns) AGAINST ($against WITH QUERY EXPANSION)" fulltext searching in the WHERE clause.
whereNotBetween() : static: Appends an "AND $column NOT BETWEEN $min AND $max" condition in the WHERE clause.
whereNotEqual() : static: Appends an "AND $column != $value" condition in the WHERE clause.
whereNotIn() : static: Appends an "AND $column NOT IN (...$values)" condition in the WHERE clause.
whereNotLike() : static: Appends an "AND $column NOT LIKE $value" condition.
whereNullSafeEqual() : static: Appends an "AND $column <=> $value" condition in the WHERE clause.
renderHaving() : string|null: Renders the full HAVING clause.
renderWhere() : string|null: Renders the full WHERE (or HAVING) clause.

having()

Appends an "AND $column $operator ...$values" condition in the HAVING clause.


    public
                    having(Closure|string $column, string $operator, Closure|float|int|string|null ...$values) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$operator : string
$values : Closure|float|int|string|null

Return values

static

havingBetween()

Appends an "AND $column BETWEEN $min AND $max" condition in the HAVING clause.


    public
                    havingBetween(Closure|string $column, Closure|float|int|string|null $min, Closure|float|int|string|null $max) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$min : Closure|float|int|string|null
$max : Closure|float|int|string|null

Return values

static

havingEqual()

Appends an "AND $column = $value" condition in the HAVING clause.


    public
                    havingEqual(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

havingGreaterThan()

Appends an "AND $column > $value" condition in the HAVING clause.


    public
                    havingGreaterThan(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

havingGreaterThanOrEqual()

Appends an "AND $column >= $value" condition in the HAVING clause.


    public
                    havingGreaterThanOrEqual(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

havingIn()

Appends an "AND $column IN (...$values)" condition in the HAVING clause.


    public
                    havingIn(Closure|string $column, Closure|float|int|string|null $value, Closure|float|int|string|null ...$values) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null
$values : Closure|float|int|string|null

Return values

static

havingIsNotNull()

Appends an "AND $column IS NOT NULL" condition in the HAVING clause.


    public
                    havingIsNotNull(Closure|string $column) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name

Return values

static

havingIsNull()

Appends an "AND $column IS NULL" condition in the HAVING clause.


    public
                    havingIsNull(Closure|string $column) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name

Return values

static

havingLessThan()

Appends an "AND $column < $value" condition in the HAVING clause.


    public
                    havingLessThan(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

havingLessThanOrEqual()

Appends an "AND $column <= $value" condition in the HAVING clause.


    public
                    havingLessThanOrEqual(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

havingLike()

Appends an "AND $column LIKE $value" condition in the HAVING clause.


    public
                    havingLike(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

havingNotBetween()

Appends an "AND $column NOT BETWEEN $min AND $max" condition in the HAVING clause.


    public
                    havingNotBetween(Closure|string $column, Closure|float|int|string|null $min, Closure|float|int|string|null $max) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$min : Closure|float|int|string|null
$max : Closure|float|int|string|null

Return values

static

havingNotEqual()

Appends an "AND $column != $value" condition in the HAVING clause.


    public
                    havingNotEqual(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

havingNotIn()

Appends an "AND $column NOT IN (...$values)" condition in the HAVING clause.


    public
                    havingNotIn(Closure|string $column, Closure|float|int|string|null $value, Closure|float|int|string|null ...$values) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null
$values : Closure|float|int|string|null

Return values

static

havingNotLike()

Appends an "AND $column NOT LIKE" $value condition.


    public
                    havingNotLike(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

havingNullSafeEqual()

Appends an "AND $column <=> $value" condition in the HAVING clause.


    public
                    havingNullSafeEqual(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

orHaving()

Appends a "OR $column $operator ...$values" condition in the HAVING clause.


    public
                    orHaving(Closure|string $column, string $operator, Closure|float|int|string|null ...$values) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$operator : string
$values : Closure|float|int|string|null

Return values

static

orHavingBetween()

Appends a "OR $column BETWEEN $min AND $max" condition in the HAVING clause.


    public
                    orHavingBetween(Closure|string $column, Closure|float|int|string|null $min, Closure|float|int|string|null $max) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$min : Closure|float|int|string|null
$max : Closure|float|int|string|null

Return values

static

orHavingEqual()

Appends a "OR $column = $value" condition in the HAVING clause.


    public
                    orHavingEqual(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

orHavingGreaterThan()

Appends a "OR $column > $value" condition in the HAVING clause.


    public
                    orHavingGreaterThan(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

orHavingGreaterThanOrEqual()

Appends a "OR $column >= $value" condition in the HAVING clause.


    public
                    orHavingGreaterThanOrEqual(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

orHavingIn()

Appends a "OR $column IN (...$values)" condition in the HAVING clause.


    public
                    orHavingIn(Closure|string $column, Closure|float|int|string|null $value, Closure|float|int|string|null ...$values) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null
$values : Closure|float|int|string|null

Return values

static

orHavingIsNotNull()

Appends a "OR $column IS NOT NULL" condition in the HAVING clause.


    public
                    orHavingIsNotNull(Closure|string $column) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name

Return values

static

orHavingIsNull()

Appends a "OR $column IS NULL" condition in the HAVING clause.


    public
                    orHavingIsNull(Closure|string $column) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name

Return values

static

orHavingLessThan()

Appends a "OR $column < $value" condition in the HAVING clause.


    public
                    orHavingLessThan(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

orHavingLessThanOrEqual()

Appends a "OR $column <= $value" condition in the HAVING clause.


    public
                    orHavingLessThanOrEqual(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

orHavingLike()

Appends a "OR $column LIKE $value" condition in the HAVING clause.


    public
                    orHavingLike(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

orHavingNotBetween()

Appends a "OR $column NOT BETWEEN $min AND $max" condition in the HAVING clause.


    public
                    orHavingNotBetween(Closure|string $column, Closure|float|int|string|null $min, Closure|float|int|string|null $max) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$min : Closure|float|int|string|null
$max : Closure|float|int|string|null

Return values

static

orHavingNotEqual()

Appends a "OR $column != $value" condition in the HAVING clause.


    public
                    orHavingNotEqual(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

orHavingNotIn()

Appends a "OR $column NOT IN (...$values)" condition in the HAVING clause.


    public
                    orHavingNotIn(Closure|string $column, Closure|float|int|string|null $value, Closure|float|int|string|null ...$values) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null
$values : Closure|float|int|string|null

Return values

static

orHavingNotLike()

Appends a "OR $column NOT LIKE $value" condition in the HAVING clause.


    public
                    orHavingNotLike(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

orHavingNullSafeEqual()

Appends a "OR $column <=> $value" condition in the HAVING clause.


    public
                    orHavingNullSafeEqual(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

orWhere()

Appends a "OR $column $operator ...$values" condition in the WHERE clause.


    public
                    orWhere(Closure|array<string|int, Closure|array<string|int, mixed>|string>|string $column, string $operator, Closure|array<string|int, Closure|array<string|int, mixed>|float|int|string|null>|float|int|string|null ...$values) : static

Parameters

$column : Closure|array<string|int, Closure|array<string|int, mixed>|string>|string: Closure for a subquery, a string with the column name or an array with column names on WHERE MATCH clause
$operator : string
$values : Closure|array<string|int, Closure|array<string|int, mixed>|float|int|string|null>|float|int|string|null

Return values

static

orWhereBetween()

Appends a "OR $column BETWEEN $min AND $max" condition in the WHERE clause.


    public
                    orWhereBetween(Closure|string $column, Closure|float|int|string|null $min, Closure|float|int|string|null $max) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$min : Closure|float|int|string|null
$max : Closure|float|int|string|null

Return values

static

orWhereEqual()

Appends a "OR $column = $value" condition in the WHERE clause.


    public
                    orWhereEqual(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

orWhereGreaterThan()

Appends a "OR $column > $value" condition in the WHERE clause.


    public
                    orWhereGreaterThan(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

orWhereGreaterThanOrEqual()

Appends a "OR $column >= $value" condition in the WHERE clause.


    public
                    orWhereGreaterThanOrEqual(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

orWhereIn()

Appends a "OR $column IN (...$values)" condition in the WHERE clause.


    public
                    orWhereIn(Closure|string $column, Closure|float|int|string|null $value, Closure|float|int|string|null ...$values) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null
$values : Closure|float|int|string|null

Return values

static

orWhereIsNotNull()

Appends a "OR $column IS NOT NULL" condition in the WHERE clause.


    public
                    orWhereIsNotNull(Closure|string $column) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name

Return values

static

orWhereIsNull()

Appends a "OR $column IS NULL" condition in the WHERE clause.


    public
                    orWhereIsNull(Closure|string $column) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name

Return values

static

orWhereLessThan()

Appends a "OR $column < $value" condition in the WHERE clause.


    public
                    orWhereLessThan(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

orWhereLessThanOrEqual()

Appends a "OR $column <= $value" condition in the WHERE clause.


    public
                    orWhereLessThanOrEqual(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

orWhereLike()

Appends a "OR $column LIKE $value" condition in the WHERE clause.


    public
                    orWhereLike(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

orWhereMatch()

Appends a "OR MATCH (...$columns) AGAINST ($against IN NATURAL LANGUAGE MODE)" fulltext searching in the WHERE clause.


    public
                    orWhereMatch(Closure|array<string|int, Closure|array<string|int, mixed>|string>|string $columns, Closure|array<string|int, Closure|array<string|int, mixed>|string>|string $against) : static

Parameters

$columns : Closure|array<string|int, Closure|array<string|int, mixed>|string>|string: Columns to MATCH
$against : Closure|array<string|int, Closure|array<string|int, mixed>|string>|string: AGAINST expression

Return values

static

orWhereMatchInBooleanMode()

Appends a "OR MATCH (...$columns) AGAINST ($against IN BOOLEAN MODE)" fulltext searching in the WHERE clause.


    public
                    orWhereMatchInBooleanMode(Closure|array<string|int, Closure|array<string|int, mixed>|string>|string $columns, Closure|array<string|int, Closure|array<string|int, mixed>|string>|string $against) : static

Parameters

$columns : Closure|array<string|int, Closure|array<string|int, mixed>|string>|string: Columns to MATCH
$against : Closure|array<string|int, Closure|array<string|int, mixed>|string>|string: AGAINST expression

Return values

static

orWhereMatchWithQueryExpansion()

Appends a "OR MATCH (...$columns) AGAINST ($against WITH QUERY EXPANSION)" fulltext searching in the WHERE clause.


    public
                    orWhereMatchWithQueryExpansion(Closure|array<string|int, Closure|array<string|int, mixed>|string>|string $columns, Closure|array<string|int, Closure|array<string|int, mixed>|string>|string $against) : static

Parameters

$columns : Closure|array<string|int, Closure|array<string|int, mixed>|string>|string: Columns to MATCH
$against : Closure|array<string|int, Closure|array<string|int, mixed>|string>|string: AGAINST expression

Return values

static

orWhereNotBetween()

Appends a "OR $column NOT BETWEEN $min AND $max" condition in the WHERE clause.


    public
                    orWhereNotBetween(Closure|string $column, Closure|float|int|string|null $min, Closure|float|int|string|null $max) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$min : Closure|float|int|string|null
$max : Closure|float|int|string|null

Return values

static

orWhereNotEqual()

Appends a "OR $column != $value" condition in the WHERE clause.


    public
                    orWhereNotEqual(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

orWhereNotIn()

Appends a "OR $column NOT IN (...$values)" condition in the WHERE clause.


    public
                    orWhereNotIn(Closure|string $column, Closure|float|int|string|null $value, Closure|float|int|string|null ...$values) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null
$values : Closure|float|int|string|null

Return values

static

orWhereNotLike()

Appends a "OR $column NOT LIKE $value" condition in the WHERE clause.


    public
                    orWhereNotLike(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

orWhereNullSafeEqual()

Appends a "OR $column <=> $value" condition in the WHERE clause.


    public
                    orWhereNullSafeEqual(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

where()

Appends an "AND $column $operator ...$values" condition in the WHERE clause.


    public
                    where(Closure|array<string|int, Closure|array<string|int, mixed>|string>|string $column, string $operator, Closure|array<string|int, Closure|array<string|int, mixed>|float|int|string|null>|float|int|string|null ...$values) : static

Parameters

$column : Closure|array<string|int, Closure|array<string|int, mixed>|string>|string: Closure for a subquery, a string with the column name or an array with column names on WHERE MATCH clause
$operator : string
$values : Closure|array<string|int, Closure|array<string|int, mixed>|float|int|string|null>|float|int|string|null

Return values

static

whereBetween()

Appends an "AND $column BETWEEN $min AND $max" condition in the WHERE clause.


    public
                    whereBetween(Closure|string $column, Closure|float|int|string|null $min, Closure|float|int|string|null $max) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$min : Closure|float|int|string|null
$max : Closure|float|int|string|null

Return values

static

whereEqual()

Appends an "AND $column = $value" condition in the WHERE clause.


    public
                    whereEqual(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

whereGreaterThan()

Appends an "AND $column > $value" condition in the WHERE clause.


    public
                    whereGreaterThan(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

whereGreaterThanOrEqual()

Appends an "AND $column >= $value" condition in the WHERE clause.


    public
                    whereGreaterThanOrEqual(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

whereIn()

Appends an "AND $column IN (...$values)" condition in the WHERE clause.


    public
                    whereIn(Closure|string $column, Closure|float|int|string|null $value, Closure|float|int|string|null ...$values) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null
$values : Closure|float|int|string|null

Return values

static

whereIsNotNull()

Appends an "AND $column IS NOT NULL" condition in the WHERE clause.


    public
                    whereIsNotNull(Closure|string $column) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name

Return values

static

whereIsNull()

Appends an "AND $column IS NULL" condition in the WHERE clause.


    public
                    whereIsNull(Closure|string $column) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name

Return values

static

whereLessThan()

Appends an "AND $column < $value" condition in the WHERE clause.


    public
                    whereLessThan(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

whereLessThanOrEqual()

Appends an "AND $column <= $value" condition in the WHERE clause.


    public
                    whereLessThanOrEqual(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

whereLike()

Appends an "AND $column LIKE $value" condition in the WHERE clause.


    public
                    whereLike(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

whereMatch()

Appends an "AND MATCH (...$columns) AGAINST ($against IN NATURAL LANGUAGE MODE)" fulltext searching in the WHERE clause.


    public
                    whereMatch(Closure|array<string|int, Closure|array<string|int, mixed>|string>|string $columns, Closure|array<string|int, Closure|array<string|int, mixed>|string>|string $against) : static

Parameters

$columns : Closure|array<string|int, Closure|array<string|int, mixed>|string>|string: Columns to MATCH
$against : Closure|array<string|int, Closure|array<string|int, mixed>|string>|string: AGAINST expression

Return values

static

whereMatchInBooleanMode()

Appends an "AND MATCH (...$columns) AGAINST ($against IN BOOLEAN MODE)" fulltext searching in the WHERE clause.


    public
                    whereMatchInBooleanMode(Closure|array<string|int, Closure|array<string|int, mixed>|string>|string $columns, Closure|array<string|int, Closure|array<string|int, mixed>|string>|string $against) : static

Parameters

$columns : Closure|array<string|int, Closure|array<string|int, mixed>|string>|string: Columns to MATCH
$against : Closure|array<string|int, Closure|array<string|int, mixed>|string>|string: AGAINST expression

Return values

static

whereMatchWithQueryExpansion()

Appends an "AND MATCH (...$columns) AGAINST ($against WITH QUERY EXPANSION)" fulltext searching in the WHERE clause.


    public
                    whereMatchWithQueryExpansion(Closure|array<string|int, Closure|array<string|int, mixed>|string>|string $columns, Closure|array<string|int, Closure|array<string|int, mixed>|string>|string $against) : static

Parameters

$columns : Closure|array<string|int, Closure|array<string|int, mixed>|string>|string: Columns to MATCH
$against : Closure|array<string|int, Closure|array<string|int, mixed>|string>|string: AGAINST expression

Return values

static

whereNotBetween()

Appends an "AND $column NOT BETWEEN $min AND $max" condition in the WHERE clause.


    public
                    whereNotBetween(Closure|string $column, Closure|float|int|string|null $min, Closure|float|int|string|null $max) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$min : Closure|float|int|string|null
$max : Closure|float|int|string|null

Return values

static

whereNotEqual()

Appends an "AND $column != $value" condition in the WHERE clause.


    public
                    whereNotEqual(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

whereNotIn()

Appends an "AND $column NOT IN (...$values)" condition in the WHERE clause.


    public
                    whereNotIn(Closure|string $column, Closure|float|int|string|null $value, Closure|float|int|string|null ...$values) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null
$values : Closure|float|int|string|null

Return values

static

whereNotLike()

Appends an "AND $column NOT LIKE $value" condition.


    public
                    whereNotLike(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

whereNullSafeEqual()

Appends an "AND $column <=> $value" condition in the WHERE clause.


    public
                    whereNullSafeEqual(Closure|string $column, Closure|float|int|string|null $value) : static

Parameters

$column : Closure|string: Closure for a subquery or a string with the column name
$value : Closure|float|int|string|null

Return values

static

renderHaving()

Renders the full HAVING clause.


    protected
                    renderHaving() : string|null

Return values

string|null —

The full clause or null if has not a clause

renderWhere()

Renders the full WHERE (or HAVING) clause.


    protected
                    renderWhere([string $clause = 'where' ]) : string|null

Parameters

$clause : string = 'where': where or having

Return values

string|null —

The full clause or null if has not a clause

Having uses trait:short

Table of Contents

Methods

Methods

having()

Parameters

Return values

havingBetween()

Parameters

Tags

Return values

havingEqual()

Parameters

Tags

Return values

havingGreaterThan()

Parameters

Tags

Return values

havingGreaterThanOrEqual()

Parameters

Tags

Return values

havingIn()

Parameters

Tags

Return values

havingIsNotNull()

Parameters

Tags

Return values

havingIsNull()

Parameters

Tags

Return values

havingLessThan()

Parameters

Tags

Return values

havingLessThanOrEqual()

Parameters

Tags

Return values

havingLike()

Parameters

Tags

Return values

havingNotBetween()

Parameters

Tags

Return values

havingNotEqual()

Parameters

Tags

Return values

havingNotIn()

Parameters

Tags

Return values

havingNotLike()

Parameters

Tags

Return values

havingNullSafeEqual()

Parameters

Tags

Return values

orHaving()

Parameters

Return values

orHavingBetween()

Parameters

Tags

Return values

orHavingEqual()

Parameters

Tags

Return values

orHavingGreaterThan()

Parameters