tp whereOr用法2
有时候会用到多个whereOr 可以用闭包来完成查询
Db::name('table_name')
->whereOr([
['age','null',''],
['age','=','']
])
->select();
Db::name('table_name')
->whereOr([
['birthday','null',''],
['birthday','=','']
])
->select();
这两个是OR(或)关系
Db::name('table_name')
->whereOr([
['age','null',''],
['age','=','']
])
->whereOr([
['birthday','null',''],
['birthday','=','']
])
->select();
这两个是AND(与)关系
Db::name('table_name')
->where(function($query){
$query->whereOr([
['age','null',''],
['age','=','']
]);
})
->where(function($query){
->whereOr([
['birthday','null',''],
['birthday','=','']
]);
})
->select();