/** * 设置筛选条件IsNotNull * * @param $fieldName * * @return $this */ public function havingIsNotNull($fieldName) { $this->having->where($fieldName, NULL, 'IS NOT NULL'); return $this; }
/** * exists * * @param Select $select * * @return $this */ public function notExists(Select $select) { $this->condition->where('', $select, 'NOT EXISTS'); return $this; }