SELECT * FROM Users WHERE DATE_FORMAT(fecha_nac,'%m-%d') = DATE_FORMAT('date', '%m-%d')
'2018-08-31'
All users whose fecha_nac (month and day) are the same of 'date' content
public function getBirthdays(){ $queryBuilder = $em->createQueryBuilder(); $queryBuilder ->select("*") ->from("Users") ->where("DATE_FORMAT(fecha_nac,'%m-%d') = DATE_FORMAT(NOW(), '%m-%d')"); return $queryBuilder->execute()->fetchAll(); }