sql复杂的查询 [ 2.0 版本 ]

我来写一下,哈哈

Tabel::find()->where(['and','a=1','b in(1,2,3)'])->orWhere('and','a=2','b in(4,5,6)');

想看着正常点,也可以这样

Tabel::find()->where(['and', ['a' => 1,'b' => [1,2]]])->orWhere(['and',['a' => 2,'b' => [4,5,6]]]);

66666666

Model::findBySql(SELECT * from table where ( a=1 AND (b IN (1,2,3)) ) OR ( a=2 AND (b IN (4,5,6)) ))->one();

Table::find()->where([
   'or',
   [
      'and',
      [
         '=',
         'a',
         1
      ],
      [
         'in',
         'b',
         [1,2,3]
      ]
   ],
   [
      'and',
      [
          '=',
          'a',
          2
      ],
      [
         'in',
         'b',
         [4,5,6]
      ]
   ]
]);

多看看文档，orwhere，andwhere，包括直接new db/query就好

Tabel::find()->where(['a'=>1,'b'=> [1,2,3]])->orWhere(['a'=2,'b'=> [4,5,6]])->select();