yii2判断数据库字段不为空

2020-08-24 08:17:16

yii2判断数据库字段is null,如下:

相关教程推荐: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);

更多编程相关内容,请关注php中文网编程入门栏目!

相关文章 大家在看