tp5查询一个字段不为空的数据

查询方法:

筛选查询video字段不为空的数据

 Db::name('table')->where(['is_open' => 1, 'cofc' => $this->cofc, 'video' => array('neq','')])->order('createtime DESC')->page($p, $pNum)->select();

 或者类似

array('userid'=>$_SESSION['id'],'state'=>'0','jldp'=>array('neq',''));
原文地址:https://www.cnblogs.com/wangyongx/p/15632363.html