How to use not equal to inside a Yii2 query

Question

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

Why not to just look at the docs instead of such guessing? – arogachev Jun 25 '15 at 05:33 — arogachev, Jun 25 '15 at 05:33
http://stackoverflow.com/a/32089897/2559712 – ankitr Sep 07 '15 at 10:30 — ankitr, Sep 07 '15 at 10:30

score 118 · Accepted Answer · edited Sep 17 '18 at 07:04

118

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

More about using where method and operator format

edited Sep 17 '18 at 07:04

Dzhuneyt

8,437
14
64
118

answered Jun 25 '15 at 05:11

Tony

5,797
3
26
22

12

You can also use `!=` as "not equal" operator. – arogachev Jun 25 '15 at 05:32

score 23 · Answer 2 · answered Sep 30 '15 at 08:06

You can also try this:

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

for Greater than

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

for less than

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

More check here

score 10 · Answer 3 · edited Oct 18 '16 at 00:43

Maybe this one help...:)

$query->andFilterWhere([ 'or',
                           ['<=', 'affidavit_cont', 0],
                           ['=', 'affidavit_cont1', 0],
                           ['>', 'affidavit_cont2', 0],
                           ['!=', 'affidavit_cont3', $this->affidavit3],
                           ['in', 'attempt_count', $this->attempted],

                      ]);

$query->andFilterWhere(['like', 'job_invoice.paid_status', '',]);

$query->andFilterWhere(['in', 'status_id', $this->status_id]);

$query->andFilterWhere(['between', 'last_attempt',
    strtotime(Utility::convertDate2Db($this->from_date)),
    strtotime(Utility::convertDate2Db($this->to_date))
    ]);

I've never seen it done quite like this, but really like it. Upvote :) — Bryant Makes Programs, Mar 14 '18 at 13:24

score 5 · Answer 4 · answered Jun 25 '15 at 05:40

5

The better and safe way to apply a condition.

Booking::find()->where('tour_id = :tour_id and id != :id', ['tour_id'=> $chk->tour_id, 'id' => $id])->all();

answered Jun 25 '15 at 05:40

SO-user

1,458
2
21
43

score 2 · Answer 5 · answered Jun 07 '17 at 11:48

2

You can use this

$this->find()->where(['resource_id' => $resource_id]) ->andWhere(['>=', 'start_time', $start_time])->all();

answered Jun 07 '17 at 11:48

Faizan Khattak

862
8
22

score 1 · Answer 6 · answered Feb 14 '17 at 11:49

In addiction to the @tony answer, for those who need to encapsulate a subquery here there's a quick example:

$users = User::find()                  
            ->where([
                'not in',
                'id',
                (new Query())
                    ->select('user_id')
                    ->from(MyTable::tableName())
                    ->where(['related_id'=>$myRelatedId])
            ->all();

score 1 · Answer 7 · edited Aug 17 '22 at 23:06

1

<?= $form->field($model, 'first_name')->dropDownList(
     ArrayHelper::map(user::find()->where([ 
        'not in ' ,
        'first_name', 
        patient::find()
           ->select([ 'patient_name' ])
           ->asArray()  
     ])
     ->all(),'id','first_name')

Maybe it help you for whom need to use subquery .

edited Aug 17 '22 at 23:06

Skatox

4,237
12
42
47

answered Jul 30 '17 at 07:01

Naeem Marzu

186
2
14

score 0 · Answer 8 · edited Apr 14 '21 at 08:51

0

You can just use the below pasted code:

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

edited Apr 14 '21 at 08:51

Juan Antonio

2,451
3
24
34

answered Dec 08 '16 at 12:46

Mohan Prasad

682
1
9
34

score 0 · Answer 9 · answered Jan 08 '19 at 17:39

0

In case anyone reading this needs to use a REGEXP or similar, this works in Yii2 (2.0.15.1):

->andWhere(['NOT REGEXP', 'column','[A-Za-z]'])

answered Jan 08 '19 at 17:39

Xavi Esteve

1,114
2
19
35

How to use not equal to inside a Yii2 query

9 Answers9

Linked