blocks|key|4513633|text|其中一个选项是：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4513634|$query+=+new+Query;+++++++++++++
$query->select('ID,+City,State,StudentName')
++++->from('student')
++++->where(['IsActive'+=>+1])
++++->andWhere(['<>',+'City',+null])
++++->andWhere(['<>',+'State',+null])
++++->orderBy(['rand()'+=>+SORT_DESC])
++++->limit(10);|code-block|syntax|javascript|4513635|查看官方文档中的where。|offset|length|4513636|entityMap|0|LINK|mutability|MUTABLE|url|http://www.yiiframework.com/doc-2.0/yii-db-queryinterface.html#where%2528%2529-detail^0|0|0|8|5|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

One of the options will be:

<pre><code>$query = new Query; 
$query-&gt;select('ID, City,State,StudentName')
 -&gt;from('student')
 -&gt;where(['IsActive' =&gt; 1])
 -&gt;andWhere(['&lt;&gt;', 'City', null])
 -&gt;andWhere(['&lt;&gt;', 'State', null])
 -&gt;orderBy(['rand()' =&gt; SORT_DESC])
 -&gt;limit(10);
</code></pre>

Check official docs for <a href="http://www.yiiframework.com/doc-2.0/yii-db-queryinterface.html#where%28%29-detail" rel="noreferrer">where</a>.

blocks|key|6306|text|您可以结合使用SQL运算符和不应为空的字段来生成IS+NOT+NULL+not语句。如下所示：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|6307|$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);|code-block|syntax|javascript|6308|还要检查documentation中的示例。|6309|entityMap|0|LINK|mutability|MUTABLE|url|http://www.yiiframework.com/doc-2.0/yii-db-query.html#where()-detail)^0|O|B|10|3|0|0|4|D|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]|$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|Z|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|10|8|@]|D|@$9|11|A|12|1|13]]|E|$]]|$1|M|3|-4|5|6|7|14|8|@]|D|@]|E|$]]]|N|$O|$5|P|Q|R|E|$S|T]]]]

You can use the <code>not</code> operator combined with the fields that should not be null to generate a <code>IS NOT NULL</code> SQL statement. Like this:

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

Also check the examples in the <a href="http://www.yiiframework.com/doc-2.0/yii-db-query.html#where()-detail">documentation</a>.

blocks|key|4513791|text|++++$items+=+BadOffer::find()->where(['OR',
+++++++++++++++++++++++++++++++++++++++++++++++['IS',+'moderator_id',+(new+Expression('Null'))],
+++++++++++++++++++++++++++++++++++++++++++++++['moderator_id'+=>+$user->id],
++++]);|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|4513792|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code> $items = BadOffer::find()-&gt;where(['OR',
 ['IS', 'moderator_id', (new Expression('Null'))],
 ['moderator_id' =&gt; $user-&gt;id],
 ]);
</code></pre>

blocks|key|6411|text|->where(['IS+NOT',+'column',+null]);|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|6412|到达|unstyled|6413|WHERE+column+IS+NOT+NULL|offset|length|style|CODE|6414|你也可以使用，它打字速度更快|6415|->where('column+IS+NOT+NULL')|6416|在复杂查询中|6417|->where(['AND',
++'column1+IS+NOT+NULL',+//+works
++['IS+NOT',+'column2',+null],+//+works
++['column3'+=>+$value],
)|6418|entityMap^0|0|0|0|O|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|X|8|@]|9|@]|A|$]]|$1|G|3|H|5|F|7|Y|8|@$I|Z|J|10|K|L]]|9|@]|A|$]]|$1|M|3|N|5|F|7|11|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|12|8|@]|9|@]|A|$B|C]]|$1|Q|3|R|5|F|7|13|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|14|8|@]|9|@]|A|$B|C]]|$1|U|3|-4|5|F|7|15|8|@]|9|@]|A|$]]]|V|$]]

<pre><code>-&gt;where(['IS NOT', 'column', null]);
</code></pre>
get
<code>WHERE column IS NOT NULL</code>
You can also use, it is faster to type
<pre><code>-&gt;where('column IS NOT NULL')
</code></pre>
In complex query
<pre><code>-&gt;where(['AND',
 'column1 IS NOT NULL', // works
 ['IS NOT', 'column2', null], // works
 ['column3' =&gt; $value],
)
</code></pre>

blocks|key|6446|text|在Yii2中，我们可以使用下面的任何查询来验证null条件，|type|unstyled|depth|inlineStyleRanges|entityRanges|data|6447|->andWhere(['NOT',+['city'+=>+null]]);|code-block|syntax|javascript|6448|或|6449|->andWhere(['<>',+['city'+=>+null]]);|6450|6451|->andWhere('city+IS+NOT+NULL');|6452|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Q|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|R|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|S|8|@]|9|@]|A|$E|F]]|$1|K|3|H|5|6|7|T|8|@]|9|@]|A|$]]|$1|L|3|M|5|D|7|U|8|@]|9|@]|A|$E|F]]|$1|N|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|O|$]]

In Yii2, we can use any of the queries below to verify the null condition,
<pre><code>-&gt;andWhere(['NOT', ['city' =&gt; null]]);
</code></pre>
or
<pre><code>-&gt;andWhere(['&lt;&gt;', ['city' =&gt; null]]);
</code></pre>
or
<pre><code>-&gt;andWhere('city IS NOT NULL');
</code></pre>

blocks|key|6479|text|这对我来说是有效的，但仅当将null作为字符串传递时|type|unstyled|depth|inlineStyleRanges|entityRanges|data|6480|->andFilterWhere(['<>',+'`city`',+'null']);+|code-block|syntax|javascript|6481|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This work for me, but only when pass null as string

<pre><code>-&gt;andFilterWhere(['&lt;&gt;', '`city`', 'null']); 
</code></pre>

Hi i want to use not null condition in my yii2 query how should i use that.
i don't want city and state null. 

My query is

<pre><code>$query = new Query; 
 $query-&gt;select('ID, City,State,StudentName') 
 -&gt;from('student') 
 -&gt;where(['IsActive' =&gt; 1]) 
 -&gt;orderBy(['rand()' =&gt; SORT_DESC])
 -&gt;limit(10); 
 $dataProvider = new ActiveDataProvider([
 'query' =&gt; $query,
 'pagination' =&gt; false,
 ]);
</code></pre>

how to use not null condition in YII2

您好，我想在我的yii2查询中使用not null条件，我应该如何使用它。我不希望城市和州为空。我的问题是$query = new Query;                   $query->select('ID, City,State,StudentName')                         ...

问如何在YII2中使用not null条件
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在YII2中使用not null条件EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在YII2中使用not null条件
EN