use sql function with querybuilder

Yii 2.0 General Discussions
1

Hi

How would I use a built in SQL function with Querybuilder? I am trying to use IFNULL within a select statement

My code is:




$q = new Query;

$q->select('score');


// I tried $q->select('IFNULL(score,0)');

But that got parsed as SELECT IFNULL(score, 0)

Thanks

2

Wrap it with http://www.yiiframework.com/doc-2.0/yii-db-expression.html

3

Hi alex

I tried:




$expression = new Expression('IFNULL(score, 0)');

                    $query->select($expression);

But it still got executed as




SELECT IFNULL(score, `0)`

What did I do wrong?

4

try it:




$q->select(['IFNULL(score,0)']);
5

No that didn’t work either :frowning:

6

What is error message ?

This is working with postgres driver.

You may use selectOptions property too.

7

My mistake, it does work. I was tired last night.

Jonathon