Scope Methods
Scope and group your queries using these methods.
having()
limit()
offset()
table( string | array )
Set the name of the table to query.
Include a table alias using an array.
columns( string $name | array $names)
Select which columns to return. Can be a single column or an array of columns.
where( array $conditions )
Filter the query using an array of keys and values. For example WHERE id = 1
or WHERE id IN (1,2)
or Mysql functions like CURDATE() or DATE_SUB(). For example WHERE created = CURDATE()
or using operators in combination with the column key (separated by colon). For example: WHERE id >= 1
or WHERE email LIKE '%.com'
.
Supported operators =, !=, <, >, <=, >=, LIKE, NOT LIKE, IS, IS NOT
. The default operator is =
.
orderBy( string $column | array $columns )
Sort the results by one or more columns including sort order ORDER BY created DESC
.
groupBy( string $column | array $columns )
Group rows by columns.
Query
JSON
Last updated