Builder|Builder whereMonth(string $column, string $operator, mixed $value = null, string $boolean = 'and') Add a "where month" statement to the query. Parameters string $column string $operator mixed $value string $boolean Return Value Builder|Builder

$this whereIn(string $column, mixed $values, string $boolean = 'and', bool $not = false) Add a "where in" clause to the query. Parameters string $column mixed $values string $boolean bool $not Return Value $this

Builder|Builder whereHas(string $relation, Closure $callback = null, string $operator = '>=', int $count = 1) Add a relationship count / exists condition to the query with where clauses. Parameters string $relation Closure $callback string $operator int $count Return Value Builder|Builder

$this whereExists(Closure $callback, string $boolean = 'and', bool $not = false) Add an exists clause to the query. Parameters Closure $callback string $boolean bool $not Return Value $this

Builder|Builder whereDoesntHave(string $relation, Closure $callback = null) Add a relationship count / exists condition to the query with where clauses. Parameters string $relation Closure $callback Return Value Builder|Builder

Builder|Builder whereDay(string $column, string $operator, mixed $value = null, string $boolean = 'and') Add a "where day" statement to the query. Parameters string $column string $operator mixed $value string $boolean Return Value Builder|Builder

Builder|Builder whereDate(string $column, string $operator, mixed $value = null, string $boolean = 'and') Add a "where date" statement to the query. Parameters string $column string $operator mixed $value string $boolean Return Value Builder|Builder

Builder|Builder whereColumn(string|array $first, string|null $operator = null, string|null $second = null, string|null $boolean = 'and') Add a "where" clause comparing two columns to the query. Parameters string|array $first string|null $operator string|null $second string|null $boolean Return Value Builder|Builder

$this whereBetween(string $column, array $values, string $boolean = 'and', bool $not = false) Add a where between statement to the query. Parameters string $column array $values string $boolean bool $not Return Value $this

$this where(string|array|Closure $column, string $operator = null, mixed $value = null, string $boolean = 'and') Add a basic where clause to the query. Parameters string|array|Closure $column string $operator mixed $value string $boolean Return Value $this