How would I do MySQL count(*) in Doctrine2?
You should be able to do it just like this (building the query as a string):
$query = $em->createQuery('SELECT COUNT(u.id) FROM Entities\User u');$count = $query->getSingleScalarResult();
You're trying to do it in DQL not "in Doctrine 2".
You need to specify which field (note, I don't use the term column) you want to count, this is because you are using an ORM, and need to think in OOP way.
$qb = $em->createQueryBuilder() ->select('t.tag_text, COUNT(t.tag_text) as num_tags') ->from('CompanyWebsiteBundle:Tag2Post', 't2p') ->innerJoin('t2p.tags', 't') ->groupBy('t.tag_text');$tags = $qb->getQuery()->getResult();
However, if you require performance, you may want to use a NativeQuery
since your result is a simple scalar not an object.
As $query->getSingleScalarResult() expects at least one result hence throws a no result exception if there are not result found so use try catch block
try{ $query->getSingleScalarResult();}catch(\Doctrine\ORM\NoResultException $e) { /*Your stuffs..*/}