写数据库查询语句的时候,如果有两个where条件以or的关系并行,要怎么写
ggzy
|
SELECT *
FROM zt_TASK WHERE (assignedTo = 'admin' OR mailto LIKE "%,admin%") AND deleted = "0" AND zt_TASK.status NOT IN ('closed', 'cancel') |
于涛 |
您好,您这样查询看下呢 SELECT * FROM zt_TASK WHERE assignedTo = 'admin' OR mailto LIKE "%,admin%" AND deleted = "0" AND zt_TASK.status NOT IN ('closed', 'cancel') |
ggzy
|
我的意思可能没表达清楚,我想要在代码中实现我上面写的sql语句 ->where('assignedTo')->eq($this->app->user->account) 现在这样写,查出来的数据会少一条 |
ggzy
|
您这样的写法,在数据库里查询也是会少一条记录的
原帖由
于涛 于
2021-08-24 14:45:37 发表
您好,您这样查询看下呢 SELECT * FROM zt_TASK WHERE assignedTo = 'admin' OR mailto LIKE "%,admin%" AND deleted = "0" AND zt_TASK.status NOT IN ('closed', 'cancel') |
石洋洋 |
2种方案: 方案一: $this->dao->query($sql)->fetch();用于查询数据 方案二: ->where('status')->notIN('cancel, closed') ->andWhere('assignedTo',true)->eq($this->app->user->account) ->markRight(1); ->andWhere('deleted')->eq(0) |