这是我的SQL:
SELECT id,`status`,IF(`status` = 'active', 'deleted','active') AS `status-use`
FROM categories
这是我的代码:(ActionResourceModel
是Zend_Db_Table
)
$dbTable = $this->getActionResourceModel();
$select = $dbTable->select();
$select->from($dbTable,$this->getQueryColumns());
$select->order($orderClause.' '.$orderSpec);
如何添加到我的选择对象:
IF(`status` = 'active', 'deleted','active') AS `status-use`
您的选择应如下所示:
$dbTable = $this->getActionResourceModel();
$select = $dbTable->select();
$select->from(
$dbTable,
array(
'status-use' => new Zend_Db_Expr("IF(`status` = 'active', 'deleted','active')"
)
);
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句