How to write a Doctrine2 delete query

Question

How do i write a query DELETE FROM table WHERE id = 2 in doctrine2 in Zend ?

$this->_em->getrepository(something\entitity\something\table)->remove()->where('id',2) ?

Answer 1

DELETE queries

$repository = $this->_em->getRepository('My\\Entity');
$query = $repository->createQuery('DELETE FROM entity e WHERE e.id = ?1');
$query->setParameter(1, $id);
$query->execute();