Using Yii2 Query Builder, how do you set null values to empty strings?

Question

I would like Yii2's Query Builder to return empty strings for null values.

The equivalent of this:

IFNULL(Table.Column1, '')

In this:

$rows = (new \yii\db\Query())
->select(['Column1', 'Column2'])
->from('Table')
->all();

Nader Roua · Accepted Answer · 2016-07-14 01:57:13Z

2

Try this

$rows = (new \yii\db\Query())
->select(['Column1'=>'IFNULL(Column1,''), 'Column2'])
->from('Table')
->all();

answered Jul 14, 2016 at 1:57

Nader Roua

6215 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ScaisEdge · Accepted Answer · 2016-07-14 06:39:11Z

1

You can use this way

You can specify columns to be selected in either an array or a string, like the following. http://www.yiiframework.com/doc-2.0/yii-db-query.html#select()-detail

$rows = (new \yii\db\Query())
   ->select([" IFNULL(Column1,''),  Column2  "])
   ->from('Table')
   ->all();

or

$rows = (new \yii\db\Query())
   ->select([" IFNULL(Column1,'')",  Column2])
   ->from('Table')
   ->all();

answered Jul 14, 2016 at 6:39

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges