add empty column using query Builder

Yii 2.0 General Discussions
1

Hi Yii-ers

i’m trying to add empty column using query Builder




$query->select("id, name, '' as emptyColumn");

but the query result can’t generate correct sql




SELECT `id`, `name`, `''` AS `emptyColumn`

what i want is




SELECT `id`, `name`, '' AS `emptyColumn`
2 



$query->select("id, name, ['emptyColumn' => '']");