yii2判斷數(shù)據(jù)庫字段不為空

yii2判斷數(shù)據(jù)庫字段is null，如下：

相關(guān)教程推薦：yii框架

示例：

$query = new Query;               $query->select('ID, City,State,StudentName')        ->from('student')                                       ->where(['IsActive' => 1])        ->andWhere(['not', ['City' => null]])        ->andWhere(['not', ['State' => null]])        ->orderBy(['rand()' => SORT_DESC])              ->limit(10);