How to query NOT NULL with Doctrine?
Try this:
$this->createQuery('u') ->where('name IS NOT NULL') ->execute();which is standard SQL syntax. Doctrine doesn't convert Null values into proper sql.
Do it in Doctrine way, from query builder and Expr class.
$qb = $entityManager->createQueryBuilder(); $result = $qb->select('t') ->from('Test','t') ->where($qb->expr()->isNotNull('t.name')) ->groupBy('t.name') ->getQuery() ->getResult();there are also distinct() function.