$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 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

Builder when(bool $value, Closure $callback, Closure $default = null) Apply the callback's query changes if the given "value" is true. Parameters bool $value Closure $callback Closure $default Return Value Builder

mixed value(string $column) Get a single column's value from the first result of a query. Parameters string $column Return Value mixed

$this useWritePdo() Use the write pdo for query. Return Value $this

bool updateOrInsert(array $attributes, array $values = array()) Insert or update a record matching the attributes, and fill it with values. Parameters array $attributes array $values Return Value bool