Answer the question
In order to leave comments, you need to log in
How to execute JSON_EXTRACT IS NO Null in Yii2 condition?
Hello,
I'm trying this:
$query->andWhere(
'not', [new Expression("JSON_EXTRACT({$table}.datas, '$.someParam')") => null]],
)
['is', new Expression("JSON_EXTRACT({$table}.datas, '$.essomeParamb')"), null],
['like', new Expression("JSON_EXTRACT({$table}.data, '$.someParam')"), $someData],
Answer the question
In order to leave comments, you need to log in
['is not', new Expression("JSON_EXTRACT({$table}.data, '$.someParam')"), null],
=> null
does not work , null
and
the error that the second operand is not set. What do you think?
https://www.yiiframework.com/doc/api/2.0/yii-db-co...
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question