Yii2 query OR condition multiple values for 1 column

Question

I've made an API with the Yii2 framework. But I don't know how to use the OR condition in my statement.

For example: I want to get all cars with brand BMW or DODGE.

I've tried the following:

$query = Car::getCar($lang)
         ->where(['or', ['m.brand' => 'BMW'], ['m.brand' => 'DODGE']])
         ->all();

But this doesn't work. I only get it to work with one value for m.brand.

So:

$query = Car::getCar($lang)
         ->where(['m.brand' => 'BMW'])
         ->all();

Works just fine.

Tried to put in a few other ways, but I don't get this to work.
Does anyone know what I'm doing wrong?

EDIT The getCar method returns something like:

(new Query())->select(['a.auto_id'])->from('auto_new a')

EDIT 2 Got it to work with:

$query->andWhere(['or', ['m.brand' => 'BMW'], ['m.brand' => 'DODGE']])

This should work as long as static method getCar() returns ActiveQuery instance. — Bizley
– Bizley, Commented Jan 20, 2017 at 13:04
@Bizley I've added what the getCar returns. I don't think thats te problem, because a single where parameter for a single column works just fine — Wouter den Ouden
– Wouter den Ouden, Commented Jan 20, 2017 at 13:16
This is weird, it should work. What do you mean by "I don't get this to work"? Is there any error or you just don't see expected results? Please test this version with or by replacing ->all(); with ->createCommand()->rawSql; and examining the output. — Bizley
– Bizley, Commented Jan 20, 2017 at 13:23

marche · Accepted Answer · 2017-01-20 17:58:24Z

5

You can actually simplify it a lot by using an array with the values you need:

$query = Car::getCar($lang)
    ->where(['m.brand' => ['BMW', 'DODGE']])
    ->all();

This will execute with something like WHERE m.brand IN ('BMW', 'DODGE') which returns the result you are looking for.

answered Jan 20, 2017 at 17:58

marche

1,7561 gold badge14 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Eduardo · Accepted Answer · 2019-09-10 02:46:46Z

4

If I understand you well, you could use something like this:

Model::find()
             ->orWhere(['brand' => 'brand1'])
             ->orWhere(['id' => 'brand2'])
             ->all();

edited Sep 10, 2019 at 2:46

Eduardo

1,8593 gold badges38 silver badges64 bronze badges

answered Jan 20, 2017 at 13:53

Oleg

2,8318 gold badges40 silver badges63 bronze badges

1 Comment

Wouter den Ouden Over a year ago

I've replaced the where with orWhere, but it still only returns the BMW's only.

Pedro del Sol · Accepted Answer · 2017-01-20 15:53:41Z

2

where() can take an array to create sql along the lines of

SELECT * FROM car WHERE brand in ('brand1', 'brand2');

using this construct you can generate an array of brands you wish to return then use the following ActiveQuery.

$brands = ['BMW', 'DODGE'];
$query = Car::find()->where(['brand' => $brands])->all();

answered Jan 20, 2017 at 15:53

Pedro del Sol

2,8419 gold badges43 silver badges52 bronze badges

Collectives™ on Stack Overflow

Yii2 query OR condition multiple values for 1 column

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related