sql - 如何将 GREATER_THAN/LESS_THAN 运算符添加到 Zend\Db\Sql 中的数据库查询？

Question

我需要在查询中添加特殊运算符。查询:

SELECT "contests".*
FROM "contests" WHERE "status" = '-1' 
AND "level1" = '1' AND "level2" = '1' AND "level3" = '1' AND "level10" = '1' 
AND DATE(`contests`.`start`) >= '2012-03-17' AND DATE(`contests`.`stop`) <= '2013-12-20'

在 Zend Framework 2 中:

$from = '2012-03-17';
$to = '2013-12-20';
  $sql = new Sql($this->adapter);
  $select = $sql->select('contests')
     ->where($where, $combination = new Predicate\Operator($from, Predicate\Operator::OPERATOR_GREATER_THAN_OR_EQUAL_TO, $to));

但这行不通。

Answer 1

如果你这样写你的 where 子句会怎么样:-

$select->where->equalTo('status', '-1'); 
$select->where->equalTo('level1', '1'); 

等等

$select->where->greaterThanOrEqualTo('start', '2012-03-17');
$select->where->greaterThanOrEqualTo('stop', '2013-12-20');