thinkphp5 中 where条件 or,and 同时使用

最新推荐文章于 2024-08-13 15:08:50 发布

Wiley_L

最新推荐文章于 2024-08-13 15:08:50 发布

阅读量4.8k

点赞数

分类专栏： TP 文章标签： whereOr whereRaw or 和 and

本文链接：https://blog.csdn.net/weixin_42277397/article/details/103601184

版权

TP 专栏收录该内容

3 篇文章 0 订阅

订阅专栏


        $where['is_del'] = 0;
        $whereor['a'] = 1;
        $whereor['b'] = 2;
        $whereor['c'] = 3;
        $whereor['d'] = 4;
        $this->user->where($where)
        ->whereRaw('(id_1 = :a and id_2 = :b) or (id_3= :c and id_4 = :d)',$whereor,'and')
            ->select()->toArray();

        //whereRaw 第一个参数可以自由发挥
        'SELECT * FROM `user` WHERE  `is_del` = 0  AND ( (`id_1` = 1 and `id_2` = 2) or (`id_3` = 3 and `id_4` = 4) )';