How to query multiple or in andWhere in YII2

angryTom

Release： 2019-11-26 17:12:57

forward

4285 people have browsed it

How to query multiple or in andWhere in YII2

How to query multiple ors in andWhere in YII2

Complex query using multiple ors:

AND ((`name`=&#39;张三&#39;) OR (`name`=&#39;李四&#39;) OR (`name`=&#39;王五&#39;))

Copy after login

// AND ((`name`=&#39;张三&#39;) OR (`name`=&#39;李四&#39;) OR (`name`=&#39;王五&#39;))
$query->andWhere(['or',
    ['name' => '张三'],
    ['name' => '李四'],
    ['name' => '王五']
]);

Copy after login

AND (((name=‘张三’) AND (phone=‘15200000000’)) OR ((name=‘李四’) AND (phone=‘15300000000’)))

Copy after login

// AND (((`name`=&#39;张三&#39;) AND (`phone`=&#39;15200000000&#39;)) OR ((`name`=&#39;李四&#39;) AND (`phone`=&#39;15300000000&#39;)))
$query->andWhere([&#39;or&#39;,
    [&#39;and&#39;,
        [&#39;name&#39; => &#39;张三&#39;],
        [&#39;phone&#39; => &#39;15200000000&#39;]
    ],
    [&#39;and&#39;,
        [&#39;name&#39; => &#39;李四&#39;],
        [&#39;phone&#39; => &#39;15300000000&#39;]
    ]
]);

Copy after login

Recommended: " YII Tutorial》

The above is the detailed content of How to query multiple or in andWhere in YII2. For more information, please follow other related articles on the PHP Chinese website!

Related labels：

or yii2

source：cnblogs.com

Previous article：How to use forms in yii framework Next article：The difference between andWhere and andFilterWhere in yii2

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn