public Phalcon\Mvc\Model\Query\Builder where (mixed $conditions, [array $bindParams], [array $bindTypes]) Sets the query conditions $builder->where(100); $builder->where('name = "Peter"'); $builder->where('name = :name: AND id > :id:', array('name' => 'Peter', 'id' => 100));

abstract public addFrom (mixed $model, [mixed $alias]) ...

abstract public columns (mixed $columns) ...

Source on GitHub Constants string OPERATOR_OR string OPERATOR_AND Methods abstract public columns (mixed $columns) ... abstract public getColumns () ... abstract public from (mixed $models) ... abstract public addFrom (mixed $model, [mixed $alias]) ... abstract public getFrom () ... abstract public join (mixed $model, [mixed $conditions], [mixed $alias]) ... abstract public innerJoin (mixed $model, [mixed $conditions], [mixed $alias]) ... abstract public leftJoin (mixed $model, [mixed $cond

abstract public andWhere (mixed $conditions, [mixed $bindParams], [mixed $bindTypes]) ...

string OPERATOR_OR

public Phalcon\Mvc\Model\Query\Builder orWhere (string $conditions, [array $bindParams], [array $bindTypes]) Appends a condition to the current conditions using an OR operator $builder->orWhere('name = "Peter"'); $builder->orWhere('name = :name: AND id > :id:', array('name' => 'Peter', 'id' => 100));

public Phalcon\Mvc\Model\Query\Builder orderBy (string | array $orderBy) Sets an ORDER BY condition clause $builder->orderBy('Robots.name'); $builder->orderBy(array('1', 'Robots.name'));

public offset (mixed $offset) Sets an OFFSET clause $builder->offset(30);

public Phalcon\Mvc\Model\Query\Builder rightJoin (string $model, [string $conditions], [string $alias]) Adds a RIGHT join to the query $builder->rightJoin('Robots', 'r.id = RobotsParts.robots_id', 'r');