How to create an is not null query in yii2?

Question

Yii

Hello! I create a request like this:

$dr = TableName::find()->joinWith('idTb')
                            ->where(['is not', 'Date_end', null])
                            ->all();

The essence is that, it is necessary to select records where the 'Date_end' field is not null.
[0] =>
[1] =>
The query selects both 0 and 1, but only 1 is needed

Answer 1

$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);

PS 2nd result in Google search for "yii2 not null"