zend-framework2 - ZF2 - 使用 CONCAT 选择

Question

我正试图做出这样的选择:

SELECT c.*, CONCAT(c.provider_id,'#',c.name") FROM contact AS c

所以，我正在写这样的东西......

$sql = new Sql($this->adapter);
        $query = $sql->select()
        ->from(array('c' => 'contact'))
        ->columns(array("CONCAT(c.provider_id,'#',c.name"), false)

但是，结果是:

SELECT c``CONCAT(c.provider_id,'#',c.name AS CONCAT(c.provider_id,'#',c.name FROM contact AS c

我做错了什么？感谢您的帮助!

Answer 1

当我必须从表中提取一些列并添加一个 Sql 函数时，我通常使用以下代码:

$sql = new Sql($this->adapter);
$query = $sql->select()
    ->from(array('c' => 'contact'))
    ->columns(array(
        'id', 'name', 'data' => new Expression('CONCAT(c.provider_id,'#',c.name)')
    )
);

Expression是Zend\Db\Sql\Expression的一个实例，结果是:

SELECT `id`, `name`,  CONCAT(c.provider_id,'#',c.name) AS `data` FROM `contact` AS `c`