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

Builder|Builder whereTime(string $column, string $operator, int $value, string $boolean = 'and') Add a "where time" statement to the query. Parameters string $column string $operator int $value string $boolean Return Value Builder|Builder

$this with(mixed $relations) Set the relationships that should be eager loaded. Parameters mixed $relations Return Value $this

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

Builder|Builder whereNotNull(string $column, string $boolean = 'and') Add a "where not null" clause to the query. Parameters string $column string $boolean Return Value Builder|Builder

$this whereRaw(string $sql, mixed $bindings = array(), string $boolean = 'and') Add a raw where clause to the query. Parameters string $sql mixed $bindings string $boolean Return Value $this

Builder|Builder whereNotExists(Closure $callback, string $boolean = 'and') Add a where not exists clause to the query. Parameters Closure $callback string $boolean Return Value Builder|Builder

Builder|Builder whereNotIn(string $column, mixed $values, string $boolean = 'and') Add a "where not in" clause to the query. Parameters string $column mixed $values string $boolean Return Value Builder|Builder

Builder|Builder whereNested(Closure $callback, string $boolean = 'and') Add a nested where statement to the query. Parameters Closure $callback string $boolean Return Value Builder|Builder

Builder|Builder whereNotBetween(string $column, array $values, string $boolean = 'and') Add a where not between statement to the query. Parameters string $column array $values string $boolean Return Value Builder|Builder