php - Zend 按字段选择分组

Question

我有一个查询如下:

select status, count(id) as units from myTable group by status

我有一个 Zend_Db_Table 对象在我的 displosal 中用于正在使用的表，我正在尝试下面提到的代码片段来创建上面的查询:

$objTable= new Application_Model_DbTable_MyTable();
$select = $objTable -> select(Zend_Db_Table::SELECT_WITH_FROM_PART)
                    -> setIntegrityCheck(false); // i am also using joins to create the query, but this is not of concern
$select -> columns(array(
           'status' => new Zend_Db_Expr('DISTINCT(STATUS)'),
           'units'  => new Zend_Db_Expr('COUNT(id)')
           ));
$select -> group('status');

从上面的片段创建的查询如下:

select myTable.*, DISTINCT(STATUS) as status, COUNT(id) as units from myTable group by status

我想从生成的查询中删除 myTable.*。

Answer 1

$select = $db ->select()
              ->distinct()
              ->from('myTable',array('status', 'COUNT(id) as units'))
              ->group('status');