如何在 Yii2 查询中使用不等于 [英] How to use not equal to inside a Yii2 query

问题描述

我想使用 yii2 查询来检查不等于条件.

I want to use a yii2 query in which I want to check a not equal to condition.

我这样试过，但没有得到想要的结果.我该怎么做?

I tried like this but it didn't give the desired results. How do I do it?

$details =  MovieShows::find()
   ->where(['movie_id'=>$id])
   ->andWhere(['location_id'=>$loc_id])
   ->andWhere(['cancel_date'=>!$date])
   ->all();

推荐答案

这种情况下你需要使用运算符格式:[operator, operation1, operand2, ...].所以你的代码应该是这样的:

In this case you need to use operator format: [operator, operand1, operand2, ...]. So your code should look like this:

$details = MovieShows::find()
           ->where(['movie_id'=>$id])
           ->andWhere(['location_id'=>$loc_id])
           ->andWhere(['<>','cancel_date', $date])
           ->all();

更多使用 where 方法和运算符格式

More about using where method and operator format

这篇关于如何在 Yii2 查询中使用不等于的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！