Zend-DB2.9- SQL与RAND顺序

Question

伙计们，我需要帮助，我正在使用zend-db 2.9 -而且我有一个需要rand()顺序的sql，但是这个查询的结果出错了我的代码：

   $sql    = new Sql($this->dbAdapter);
   $select = $sql->select(
       ['a'=>$this->table]
   );

   $select->order("RAND() ASC");
   $select->limit(1);

   $stt = $sql->prepareStatementForSqlObject($select);
   $res = $stt->execute();

结果是：

SELECT `a`.* FROM `mytable` AS `a` ORDER BY `RAND``(``)` ASC LIMIT 1

怎么修呢？

Answer 1

我找到了答案:只需添加新表达式(“RAND()”)

    $sql = new Sql($this->dbAdapter);
    $select = $sql->select(
        ['a'=>$this->table]
    );

    $select->order([new Expression("RAND() ASC")]);
    $select->limit(1);

    $stt = $sql->prepareStatementForSqlObject($select);
    $res = $stt->execute();