Yii2 select query where multiple values

Question

When I want select where IN query, how to define multiple values in where clause?

Note on the ':k'=>1 and ':k'=>, how to use it for 2 values?

$query = Model::find()->where('id = :id and type = :k' ,[':id'=>$id, ':k'=>1,':k'=>27])->count();

rob006 · Accepted Answer · 2019-05-04 11:25:53Z

2

Conditions can be also defined using array syntax:

$count = Model::find()
    ->where([
        'AND',
        ['=', 'id', $id],
        ['IN', 'type', [1, 27]],
    ])
    ->count();

answered May 4, 2019 at 11:25

rob006

22.3k5 gold badges57 silver badges77 bronze badges

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

Comments

ScaisEdge · Accepted Answer · 2019-05-04 06:47:15Z

1

You could try using IN baded on an array assuming

$myArray = array(1,27);
$query = Model::find()->where(['IN', 'id', $myArray])
    ->andWhere('id = :id', [':id' => $id])->count();

answered May 4, 2019 at 6:47

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

rob006 · Accepted Answer · 2019-05-04 08:26:41Z

1

You can do it in this way:

$types = [1, 27];
$query = Model::find()
    ->where(['id' => $id])
    ->andWhere(['type' => $types])
    ->count();

Yii2 will convert your $types array to IN condition. SQL query will be:

SELECT COUNT(*) FROM <table> WHERE id = <id> AND type IN (1, 27);

rob006

22.3k5 gold badges57 silver badges77 bronze badges

answered May 4, 2019 at 7:02

rakhmatov

3874 silver badges10 bronze badges