sql - Yii2 ActiveRecord : composite IN condition

Question

当使用 ActiveRecord 的 where() 时，如何在 ((1, 'George'), (2, 'Tom')) 中编写像 (id, name) 这样的复合 IN 条件 条件？

Answer 1

To create a composite IN condition you can use and array for the column name and value, where the values are indexed by the column name: ['in', ['id', 'name'], [['id' => 1, 'name' => 'foo'], ['id' => 2, 'name' => 'bar']]].

例如:

$models = Model::find()->where(['in', ['id', 'name'], [
    ['id' => 1, 'name' => 'George'],
    ['id' => 2, 'name' => 'Tom'],
]])->all();

阅读更多关于 ActiveQuery::where() 的信息.