Builder|Builder orWhereBetween(string $column, array $values) Add an or where between statement to the query. Parameters string $column array $values Return Value Builder|Builder

Builder|Builder orWhere(Closure|string $column, string $operator = null, mixed $value = null) Add an "or where" clause to the query. Parameters Closure|string $column string $operator mixed $value Return Value Builder|Builder

JoinClause orOn(Closure|string $first, string|null $operator = null, string|null $second = null) Add an "or on" clause to the join. Parameters Closure|string $first string|null $operator string|null $second Return Value JoinClause

Builder|Builder orHavingRaw(string $sql, array $bindings = array()) Add a raw or having clause to the query. Parameters string $sql array $bindings Return Value Builder|Builder

Builder|Builder orHaving(string $column, string $operator = null, string $value = null) Add a "or having" clause to the query. Parameters string $column string $operator string $value Return Value Builder|Builder

$this orderByRaw(string $sql, array $bindings = array()) Add a raw "order by" clause to the query. Parameters string $sql array $bindings Return Value $this

$this orderBy(string $column, string $direction = 'asc') Add an "order by" clause to the query. Parameters string $column string $direction Return Value $this

$this on(Closure|string $first, string|null $operator = null, string|null $second = null, string $boolean = 'and') Add an "on" clause to the join. On clauses can be chained, e.g. $join->on('contacts.userid', '=', 'users.id') ->on('contacts.infoid', '=', 'info.id') will produce the following SQL: on contacts.user_id = users.id and contacts.info_id = info.id Parameters Closure|string $first string|null $operator string|null $second string $boolean Return Value $this

Builder|Builder oldest(string $column = 'created_at') Add an "order by" clause for a timestamp to the query. Parameters string $column Return Value Builder|Builder

$this offset(int $value) Set the "offset" value of the query. Parameters int $value Return Value $this