Login Register

sphinx\QueryBuilder buildBetweenCondition()

buildBetweenCondition() public method

Creates an SQL expressions with the BETWEEN operator.

public string buildBetweenCondition ( $indexes, $operator, $operands, &$params )
$indexes	yii\sphinx\IndexSchema[]	List of indexes, which affected by query
$operator	string	The operator to use (e.g. `BETWEEN` or `NOT BETWEEN`)
$operands	array	The first operand is the column name. The second and third operands describe the interval that column value should be in.
$params	array	The binding parameters to be populated
return	string	The generated SQL expression
throws	yii\db\Exception	if wrong number of operands have been given.

Links:

http://www.yiiframework.com/doc-2.0/yii-sphinx-querybuilder.html#buildBetweenCondition()-detail

doc_Yii

2016-10-30 17:12:26

Comments

Leave a Comment

Please login to continue.

Popular Articles

db\QueryBuilder buildBetweenCondition() buildBetweenCondition() public method Creates an SQL expressions with the BETWEEN operator. public string buildBetweenCondition ( $operator, $o

mongodb\QueryBuilder buildBetweenCondition() buildBetweenCondition() public method Creates an Mongo condition, which emulates the BETWEEN operator. public array buildBetweenCondition ( $op

sphinx\QueryBuilder __construct() __construct() public method Constructor. public void __construct ( $connection, $config = [] )$connection yii\sphinx\Connection The Sphinx con

sphinx\QueryBuilder batchInsert() batchInsert() public method Generates a batch INSERT SQL statement. For example, $sql = $queryBuilder->batchInsert('idx_user', ['id', 'name',

sphinx\QueryBuilder buildLimit() buildLimit() public method public string buildLimit ( $limit, $offset )$limit integer $offset integer return string The LIMIT and OFFSET claus