Class Select

Select query generator

zsql\Query

Extended by

zsql\ExtendedQuery

Extended by

zsql\Select

Namespace: zsql
Located at zsql/Select.php

Methods summary
`public zsql\Select`	# `columns( mixed $columns )` Set the columns Set the columns Parameters `$columns` `mixed` $columns Returns `zsql\Select` Throws `zsql\Exception`
`public zsql\Select`	# `distinct( type $distinct = true )` Set distinct clause Set distinct clause Parameters `$distinct` `type` $distinct Returns `zsql\Select`
`public zsql\Select`	# `from( mixed $table, mixed $columns = null )` Alias for `zsql\Query::table()` and `zsql\Select::columns()` Alias for `zsql\Query::table()` and `zsql\Select::columns()` Parameters `$table` `mixed` $table `$columns` `mixed` $columns Returns `zsql\Select`
`public zsql\Select`	# `hint( mixed $columns, string $mode = null )` Hint at index to use Hint at index to use Parameters `$columns` `mixed` $columns `$mode` `string` $mode Returns `zsql\Select`
`public zsql\Select`	# `select( mixed $columns )` Alias for `zsql\Select::columns()` Alias for `zsql\Select::columns()` Parameters `$columns` `mixed` $columns Returns `zsql\Select`
`public string`	# `getResultClass( )` Get the result class Get the result class Returns `string`
`public zsql\Select`	# `setResultClass( string $class )` Set result class Set result class Parameters `$class` `string` $class Returns `zsql\Select`
`public zsql\Result`	# `query( )` Execute a query Execute a query Returns `zsql\Result` Throws `zsql\Exception` Overrides `zsql\Query::query()`
`protected`	# `assemble( )` Assemble parts Assemble parts
`protected zsql\Select`	# `pushColumns( )` Push columns onto parts Push columns onto parts Returns `zsql\Select`
`protected zsql\Select`	# `pushDistinct( )` Push distinct onto parts Push distinct onto parts Returns `zsql\Select`
`protected zsql\Select`	# `pushHint( )` Push hint onto parts Push hint onto parts Returns `zsql\Select`

Methods inherited from zsql\ExtendedQuery
`group(), limit(), offset(), order(), pushGroup(), pushLimit(), pushOrder(), pushWhere(), where(), whereExpr(), whereIn()`

Methods inherited from zsql\Query
`__construct(), __toString(), interpolateParams(), interpolation(), params(), parts(), push(), pushTable(), pushValues(), quoteIdentifier(), quoteIdentifierIfNotExpression(), setQuoteCallback(), table(), toString()`

Properties summary
`protected mixed`	`$columns`		# Columns clause Columns clause
`protected boolean`	`$distinct`		# Distinct clause Distinct clause
`protected string`	`$hint`		# Index hint clause (column) Index hint clause (column)
`protected string`	`$hintMode`		# Index hint clause (mode) Index hint clause (mode)
`protected string`	`$resultClass`		# The result class The result class

Properties inherited from zsql\ExtendedQuery
`$direction, $group, $limit, $offset, $order, $where`

Properties inherited from zsql\Query
`$database, $interpolation, $params, $parts, $query, $queryCallback, $quoteCallback, $quoteChar, $quoteIdentifierChar, $table`