Builder

$this

search(array|string $query, array $columns = null, boolean $fulltext = true, float $threshold = null)

Search through any columns on current table or any defined relations and return results ordered by search relevance.

string

getLikeOperator()

Get driver-specific case insensitive like operator.

void

prefixColumnsForJoin()

Prefix selected columns with table name in order to avoid collisions.

$this

joinRelations(array|string $relations, string $type = 'inner')

Join related tables.

$this

leftJoinRelations(array|string $relations)

Left join related tables.

$this

rightJoinRelations(array|string $relations)

Right join related tables.

static 

setParserFactory(ParserFactory $factory)

Set search query parser factory instance.

static 

setJoinerFactory(JoinerFactory $factory)

Set the relations joiner factory instance.

mixed

callParent(string $method, array $args)

Call base Eloquent method.

Collection

get(array $columns = array('*'))

Execute the query as a "select" statement.

$this

select(array $columns = array('*'))

Set the columns to be selected.

$this

where(mixed $column, string $operator = null, mixed $value = null, string $boolean = 'and')

Add where constraint to the query.

$this

orWhere(string $column, string $operator = null, mixed $value = null)

Add an "or where" clause to the query.

$this

whereBetween(string $column, array $values, string $boolean = 'and', boolean $not = false)

Add a where between statement to the query.

$this

orWhereBetween(string $column, array $values)

Add an or where between statement to the query.

$this

whereNotBetween(string $column, array $values, string $boolean = 'and')

Add a where not between statement to the query.

$this

orWhereNotBetween(string $column, array $values)

Add an or where not between statement to the query.

$this

whereIn(string $column, mixed $values, string $boolean = 'and', bool $not = false)

Add a "where in" clause to the query.

$this

orWhereIn(string $column, mixed $values)

Add an "or where in" clause to the query.

$this

whereNotIn(string $column, mixed $values, string $boolean = 'and')

Add a "where not in" clause to the query.

$this

orWhereNotIn(string $column, mixed $values)

Add an "or where not in" clause to the query.

$this

whereNull(string $column, string $boolean = 'and', bool $not = false)

Add a "where null" clause to the query.

$this

orWhereNull(string $column)

Add an "or where null" clause to the query.

$this

whereNotNull(string $column, string $boolean = 'and')

Add a "where not null" clause to the query.

$this

orWhereNotNull(string $column)

Add an "or where not null" clause to the query.

$this

whereDate(string $column, string $operator, int $value, string $boolean = 'and')

Add a "where date" statement to the query.

$this

whereDay(string $column, string $operator, int $value, string $boolean = 'and')

Add a "where day" statement to the query.

$this

whereMonth(string $column, string $operator, int $value, string $boolean = 'and')

Add a "where month" statement to the query.

$this

whereYear(string $column, string $operator, int $value, string $boolean = 'and')

Add a "where year" statement to the query.

$this

whereExists(Closure $callback, string $boolean = 'and', bool $not = false)

Add an exists clause to the query.

$this

orderBy(string $column, string $direction = 'asc')

Add an "order by" clause to the query.

$this

latest(string $column = 'created_at')

Add an "order by" clause for a timestamp to the query.

$this

oldest(string $column = 'created_at')

Add an "order by" clause for a timestamp to the query.

mixed

pluck(string $column)

Pluck a single column from the database.

mixed

aggregate(string $function, array $columns = array('*'))

Execute an aggregate function on the database.

mixed

min(string $column)

Retrieve the minimum value of a given column.

mixed

max(string $column)

Retrieve the maximum value of a given column.

mixed

avg(string $column)

Retrieve the average of the values of a given column.

mixed

sum(string $column)

Retrieve the sum of the values of a given column.

int

count(string $columns = '*')

Retrieve the "count" result of the query.

array

lists(string $column, string $key = null)

Get an array with the values of a given column.

Builder

newQuery()

Get a new instance of the Eloquence query builder.