thinkphp5.1 不等于过滤null
2022-07-28 14:14:58
312
0

在<>时过滤null

原生sql:

WHERE (`name` = 'aaa') AND WHERE(`is_deleted` <> 1OR `is_deleted` IS NULL )

thinkphp5.1链式调用

Db::table('table')->where($where)->where(function ($query) {$query->whereOr([['is_deleted', '<>', 1]])->whereOr('is_deleted', 'null');})->select();
全部回帖(0)
加载中...