title: Doctrine: How to remove part of a where clause from select query inside listener (preDqlSelect)?
body: <p>My listener is part of a behavior, that should remove all is_published checks in the where clause of any called select query. Adding a part to a clause is really easy, but how to remove one. </p>
  
  <p>There are some functions like <code>Doctrine_Query-&gt;removeDqlQueryPart('where')</code>, 
  but that removes the complete where clause, while I only need the <code>'is_published = ?'</code> part to be removed. </p>
  
  <p>However I could handle this manually somehow, with regex or something. But the tricky part is, how to remove the parameter represented by the '?' from the corresponding parameters array (retrievable by <code>Doctrine_Query-&gt;getRawParams()</code>).</p>
  
  <p>So I ask, is there a clean way to transform this kind of query:<br>
  <code>...FROM Video v WHERE v.is_published = ? AND v.start_date &lt; ? AND v.end_date &gt; ?</code></p>
  
  <p>to this stripped one and without messing up the params represented by the question marks:<br>
  <code>...FROM Video v WHERE v.start_date &lt; ? AND v.end_date &gt; ?</code></p>
  
  <p>This is of course just a simple example, my queries are a bit more complex.
  Unfortunately I'm stuck with doctrine 1.0.x because of the symfony framework.</p>