Class Core_QueryBuilder_Select

Query builder. SELECT Database Abstraction Layer (DBAL)

http://dev.mysql.com/doc/refman/5.7/en/select.html

Subqueries http://dev.mysql.com/doc/refman/5.7/en/subqueries.html

The Subquery as Scalar Operand http://dev.mysql.com/doc/refman/5.7/en/scalar-subqueries.html

// SELECT (SELECT MAX(`column2`) FROM `t2`) FROM `t1`
$oCore_QueryBuilder_Select2 = Core_QueryBuilder::select('MAX(column2)')->from('t2');
$oCore_QueryBuilder_Select = Core_QueryBuilder::select($oCore_QueryBuilder_Select2)->from('t1');

Comparisons Using Subqueries http://dev.mysql.com/doc/refman/5.7/en/comparisons-using-subqueries.html

// SELECT * FROM `t1` WHERE `column1` = (SELECT MAX(`column2`) FROM `t2`)
$oCore_QueryBuilder_Select2 = Core_QueryBuilder::select('MAX(column2)')->from('t2');

$oCore_QueryBuilder_Select = Core_QueryBuilder::select()->from('t1')
    ->where('column1', '=', $oCore_QueryBuilder_Select2);

Core_QueryBuilder_Statement

Core_QueryBuilder_Selection

Core_QueryBuilder_Select

Direct known subclasses

Search_Sphinx_QueryBuilder_Select

Package: HostCMS\Core\Querybuilder
Copyright: © 2005-2021 ООО "Хостмэйк" (Hostmake LLC), http://www.hostcms.ru
Author: Hostmake LLC
Version: 6.x
See: Core_QueryBuilder_Selection
Located at core/querybuilder/select.php

Methods summary

`public`	# `__construct( array $args = array() )` Constructor. $oCore_QueryBuilder_Select = Core_QueryBuilder::select('id', array('tableName.name', 'aliasName')); Constructor. $oCore_QueryBuilder_Select = Core_QueryBuilder::select('id', array('tableName.name', 'aliasName')); Parameters `$args` list of arguments See `Core_QueryBuilder_Select::columns()` Overrides `Core_QueryBuilder_Selection::__construct`
`public Core_QueryBuilder_Select`	# `columns( )` Add columns for select Add columns for select // SELECT `id`, `name` $Core_QueryBuilder_Select->columns('id', 'name'); // SELECT `id`, `name` AS `aliasName` $Core_QueryBuilder_Select->columns('id', array('name', 'aliasName')); // SELECT `id`, `tablename`.`name` AS `aliasName` $Core_QueryBuilder_Select->columns('id', array('tablename.name', 'aliasName')); Returns `Core_QueryBuilder_Select`
`public`	# `select( )` Alias for columns() Alias for columns() See `Core_QueryBuilder_Select::columns()`
`public array`	# `getSelect( )` Get SELECT Get SELECT Returns array
`public Core_QueryBuilder_Select`	# `clearSelect( )` Clear SELECT list Clear SELECT list Returns `Core_QueryBuilder_Select`
`public Core_QueryBuilder_Select`	# `highPriority( boolean $value = TRUE )` Set HIGH_PRIORITY Set HIGH_PRIORITY $oCore_QueryBuilder_Select = Core_QueryBuilder::select()->highPriority(); Parameters `$value` Returns `Core_QueryBuilder_Select`
`public boolean`	# `isHighPriority( )` Check if HIGH_PRIORITY was set Check if HIGH_PRIORITY was set Returns boolean
`public Core_QueryBuilder_Select`	# `straightJoin( boolean $value = TRUE )` Set STRAIGHT_JOIN Set STRAIGHT_JOIN $oCore_QueryBuilder_Select = Core_QueryBuilder::select()->straightJoin(); Parameters `$value` Returns `Core_QueryBuilder_Select`
`public boolean`	# `isStraightJoin( )` Check if STRAIGHT_JOIN was set Check if STRAIGHT_JOIN was set Returns boolean
`public Core_QueryBuilder_Select`	# `sqlCalcFoundRows( boolean $value = TRUE )` Set SQL_CALC_FOUND_ROWS Set SQL_CALC_FOUND_ROWS $oCore_QueryBuilder_Select = Core_QueryBuilder::select()->sqlCalcFoundRows(); Parameters `$value` Returns `Core_QueryBuilder_Select`
`public Core_QueryBuilder_Select`	# `selectDistinct( )` Set DISTINCT and add columns for select Set DISTINCT and add columns for select Returns `Core_QueryBuilder_Select` See `Core_QueryBuilder_Select::columns()`
`public Core_QueryBuilder_Select`	# `distinct( boolean $distinct = TRUE )` Set DISTINCT Set DISTINCT $oCore_QueryBuilder_Select = Core_QueryBuilder::select()->distinct(); Parameters `$distinct` DISTINCT option Returns `Core_QueryBuilder_Select`
`public Core_QueryBuilder_Select`	# `from( )` Set FROM Set FROM // FROM `tableName` $oCore_QueryBuilder_Select = $Core_QueryBuilder_Select->from('tableName'); // FROM `tableName` AS `tableNameAlias` $oCore_QueryBuilder_Select = $Core_QueryBuilder_Select->from(array('tableName', 'tableNameAlias')); Returns `Core_QueryBuilder_Select`
`public array`	# `getFrom( )` Get FROM Get FROM Returns array
`public Core_QueryBuilder_Select`	# `clearFrom( )` Clear FROM Clear FROM Returns `Core_QueryBuilder_Select`
`public Core_QueryBuilder_Select`	# `havingOpen( )` Open bracket in HAVING Open bracket in HAVING Returns `Core_QueryBuilder_Select`
`public Core_QueryBuilder_Select`	# `havingClose( )` Close bracket in HAVING Close bracket in HAVING Returns `Core_QueryBuilder_Select`
`public Core_QueryBuilder_Select`	# `having( string $column, string $expression, string $value )` Add HAVING Add HAVING // HAVING `a1` > '2' $Core_QueryBuilder_Select->having('a1', '>', '2'); // HAVING `a4` IN (17, 19, NULL, 'NULL') $Core_QueryBuilder_Select->having('a4', 'IN', array(17,19, NULL, 'NULL')); // HAVING `a7` BETWEEN 1 AND 10 $Core_QueryBuilder_Select->having('a7', 'BETWEEN', array(1, 10)); Parameters `$column` column `$expression` expression `$value` value Returns `Core_QueryBuilder_Select`
`public Core_QueryBuilder_Select`	# `deleteLastHaving( )` Delete last HAVING condition Delete last HAVING condition Returns `Core_QueryBuilder_Select`
`public Core_QueryBuilder_Select`	# `deleteFirstHaving( )` Delete first HAVING condition Delete first HAVING condition Returns `Core_QueryBuilder_Select`
`public Core_QueryBuilder_Select`	# `orHaving( string $column, string $expression, string $value )` Add OR and HAVING, e.g. HAVING ... OR $column $expression $value Add OR and HAVING, e.g. HAVING ... OR $column $expression $value // HAVING `a1` > 2 OR `a2` < 7 $Core_QueryBuilder_Select->having('a1', '>', 2)->orHaving('a2', '<', 7); Parameters `$column` column `$expression` expression `$value` value Returns `Core_QueryBuilder_Select`
`public Core_QueryBuilder_Select`	# `havingRaw( string $expr )` Add raw expression into HAVING. ATTENTION! Danger, you should escape the query yourself! Add raw expression into HAVING. ATTENTION! Danger, you should escape the query yourself! // HAVING `a1` > 2 $Core_QueryBuilder_Select->havingRaw("`a1` > 2"); Parameters `$expr` expression Returns `Core_QueryBuilder_Select`
`public Core_QueryBuilder_Select`	# `clearHaving( )` Clear HAVING list Clear HAVING list Returns `Core_QueryBuilder_Select`
`public Core_QueryBuilder_Select`	# `groupBy( string $column,… )` Set GROUP BY Set GROUP BY // GROUP BY `field`, COUNT(`id`) $Core_QueryBuilder_Select->groupBy('field1')->groupBy('COUNT(id)'); Parameters `$column`,… column Returns `Core_QueryBuilder_Select`
`public Core_QueryBuilder_Select`	# `group( string $column )` GROUP BY GROUP BY Parameters `$column` column Returns `Core_QueryBuilder_Select` See `Core_QueryBuilder_Select::groupBy()`
`public array`	# `getGroupBy( )` Get GROUP BY Get GROUP BY Returns array
`public Core_QueryBuilder_Select`	# `clearGroupBy( )` Clear GROUP BY list Clear GROUP BY list Returns `Core_QueryBuilder_Select`
`public Core_QueryBuilder_Select`	# `union( Core_QueryBuilder_Select $object )` UNION is used to combine the result from multiple SELECT statements into a single result set. UNION is used to combine the result from multiple SELECT statements into a single result set. // (SELECT `id2`, `name2` FROM `tablename2`) // UNION // (SELECT `id`, `name` FROM `tablename` LIMIT 10 OFFSET 0) $select1 = Core_QueryBuilder::select('id', 'name')->from('tablename') ->limit(0, 10); $select2 = Core_QueryBuilder::select('id2', 'name2')->from('tablename2') ->union($select1); Parameters `$object` Returns `Core_QueryBuilder_Select`
`public Core_QueryBuilder_Select`	# `unionAll( Core_QueryBuilder_Select $object )` UNION ALL is used to combine the result from multiple SELECT statements into a single result set. UNION ALL is used to combine the result from multiple SELECT statements into a single result set. // (SELECT `id2`, `name2` FROM `tablename2`) // UNION ALL // (SELECT `id`, `name` FROM `tablename` LIMIT 10 OFFSET 0) $select1 = Core_QueryBuilder::select('id', 'name')->from('tablename') ->limit(0, 10); $select2 = Core_QueryBuilder::select('id2', 'name2')->from('tablename2') ->unionAll($select1); Parameters `$object` Returns `Core_QueryBuilder_Select`
`public`	# `unionOrderBy( string $column, string $direction = 'ASC', boolean $binary = FALSE )` ORDER BY for UNION ORDER BY for UNION http://dev.mysql.com/doc/refman/5.7/en/union.html Parameters `$column` column `$direction` sorting direction `$binary` binary option
`public`	# `unionLimit( string $arg1, string $arg2 = NULL )` LIMIT for UNION LIMIT for UNION Parameters `$arg1` offset `$arg2` count
`public selfion`	# `unionOffset( integer $offset )` Set UNION offset Set UNION offset Parameters `$offset` offset Returns selfion
`public`	# `offsetPostgreSQLSyntax( $compatible )` Offset compatibility with PostgreSQL, default TRUE $param boolean $compatible Offset compatibility with PostgreSQL, default TRUE $param boolean $compatible
`public string`	# `build( )` Build the SQL query Build the SQL query Returns string The SQL query
`public boolean`	# `chunk( integer $count, callable $callback, boolean $bCache = TRUE )` Retrieve a small chunk and feeds each one into $callback for processing. It stops looping when $callback returns FALSE Retrieve a small chunk and feeds each one into $callback for processing. It stops looping when $callback returns FALSE Parameters `$count` chunk size `$callback` `$bCache` use cache Returns boolean
`public Core_QueryBuilder_Select`	# `clear( )` Clear Clear Returns `Core_QueryBuilder_Select` Overrides `Core_QueryBuilder_Selection::clear`

Methods inherited from Core_QueryBuilder_Selection

_buildExpression(), _buildIndexHint(), _buildJoin(), _buildOrderBy(), _buildWhere(), _join(), _quoteTables(), asAssoc(), asObject(), clearIndexHints(), clearJoin(), clearOrderBy(), clearWhere(), close(), crossJoin(), deleteFirstWhere(), deleteLastWhere(), firstJoin(), firstLeftJoin(), getJoin(), getOrderBy(), getWhere(), indexHint(), join(), leftJoin(), limit(), naturalJoin(), offset(), open(), orWhere(), orWhereBetween(), orWhereColumn(), orWhereIn(), orWhereIsNotNull(), orWhereIsNull(), orWhereNotBetween(), orWhereNotIn(), order(), orderBy(), orderByRaw(), partition(), quoteTable(), rightJoin(), rightJoinFirst(), setAnd(), setDefaultOperator(), setOperator(), setOr(), where(), whereBetween(), whereColumn(), whereIn(), whereIsNotNull(), whereIsNull(), whereNotBetween(), whereNotIn(), whereRaw()

Methods inherited from Core_QueryBuilder_Statement

__call(), __set(), _isObjectSelect(), _quoteColumns(), _quoteValues(), clearLimit(), clearOffset(), execute(), setDataBase(), unbuffered()

Properties summary

`protected boolean`	`$_distinct` DISTINCT DISTINCT	# `FALSE`
`protected boolean`	`$_highPriority` HIGH_PRIORITY HIGH_PRIORITY	# `FALSE`
`protected boolean`	`$_straightJoin` STRAIGHT_JOIN STRAIGHT_JOIN	# `FALSE`
`protected boolean`	`$_sqlCalcFoundRows` SQL_CALC_FOUND_ROWS SQL_CALC_FOUND_ROWS	# `FALSE`
`protected array`	`$_select` SELECT SELECT	# `array()`
`protected array`	`$_from` FROM FROM	# `array()`
`protected array`	`$_groupBy` GROUP BY GROUP BY	# `array()`
`protected array`	`$_having` HAVING HAVING	# `array()`
`protected array`	`$_union` Array of Core_QueryBuilder_Select's Array of Core_QueryBuilder_Select's	# `array()`
`protected array`	`$_unionOrderBy` UNION ORDER BY UNION ORDER BY	# `array()`
`protected mixed`	`$_unionLimit` UNION LIMIT UNION LIMIT	# `NULL`
`protected mixed`	`$_unionOffset` UNION OFFSET UNION OFFSET	# `NULL`
`protected integer`	`$_queryType` DataBase Query Type 0 - SELECT DataBase Query Type 0 - SELECT	# `0`
`protected boolean`	`$_offsetPostgreSQLSyntax` Offset compatibility with PostgreSQL, default TRUE Offset compatibility with PostgreSQL, default TRUE	# `TRUE`

Properties inherited from Core_QueryBuilder_Selection

$_defaultOperator, $_indexHints, $_join, $_limit, $_offset, $_operator, $_orderBy, $_partition, $_where

Properties inherited from Core_QueryBuilder_Statement

$_dataBase, $_unbuffered

Classes

Exceptions

Functions

Class Core_QueryBuilder_Select

Direct known subclasses

Methods summary

Parameters

See

Overrides

Returns

See

Returns

Returns

Parameters

Returns

Returns

Parameters

Returns

Returns

Parameters

Returns

Returns

See

Parameters

Returns

Returns

Returns

Returns

Returns

Returns

Parameters

Returns

Returns

Returns

Parameters

Returns

Parameters

Returns

Returns

Parameters

Returns

Parameters

Returns

See

Returns

Returns

Parameters

Returns

Parameters

Returns

Parameters

Parameters

Parameters

Returns

Returns

Parameters

Returns

Returns

Overrides

Methods inherited from Core_QueryBuilder_Selection

Methods inherited from Core_QueryBuilder_Statement

Properties summary

Properties inherited from Core_QueryBuilder_Selection

Properties inherited from Core_QueryBuilder_Statement