EXISTS 和 NOT EXISTS 操作符
$sql = $zbp->db->sql->get()->select($zbp->table['Post'])
->where(array('exists', 'SELECT 1'))
->sql;SELECT * FROM zbp_post WHERE EXISTS ( SELECT 1 )
「特科网」12年专注网站建设,小程序开发,SEO优化服务!
EXISTS 和 NOT EXISTS 操作符$sql = $zbp->db->sql->get()->select($zbp->table['Post'])
$sql = $zbp->db->sql->get()->select($zbp->table['Post'])
->where(array('exists', 'SELECT 1'))
->sql;SELECT * FROM zbp_post WHERE EXISTS ( SELECT 1 )