title: Doctrine/Symfony2 - DELETE FROM table WHERE field = "test"
body: <p>I can't believe I can't seem to find this anywhere (without just forcing the entire SQL in). Docs talk about adding, searching, updating and removing an entity, but I just can't see how to do what this would be in pure SQL:</p>
  
  <pre><code>DELETE FROM table WHERE field = "test"
  </code></pre>
  
  <p>I'm guessing this just adds and updates, so I can't use this:</p>
  
  <pre><code>$product = new Product();
  
  // etc.
  
  $em = $this-&gt;getDoctrine()-&gt;getEntityManager();
  $em-&gt;persist($product);
  $em-&gt;flush();
  </code></pre>
  
  <p>and I don't think the 'remove' option would do it either:</p>
  
  <pre><code>$em-&gt;remove($product);
  $em-&gt;flush();
  </code></pre>
  
  <p>So, can anyone point me in the right direction?</p>