Sunday, January 30, 2022

[FIXED] Yii condition <IS NULL>

Issue

How to find row by column with null value?

It doesn't work:

$criteria->condition = '`seller_id` IS NULL';

Solution

$criteria->addCondition('seller_id IS NULL');
$data= MODEL::model()->find($criteria);

tried this? **seller_id** is the mapped column name in Yii, it may not be same as the actual column name in your database.



Answered By - Winfred

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.