title: How do I use a complex criteria inside a doctrine 2 entity's repository?
body: <p>Lets say I have a table that holds information about festivals.<br />
  Each festival has a start and end date.</p>
  <p>I want to select all the festivals that are live (that happen) on a given date.</p>
  <p>Meaning, I want to select all the festivals that their start date is before or on a given date, and that their end date is after or on a the same given date.</p>
  <p>So I went on to the repository class of the festival entity, and created a method to do just that.<br />
  But the criteria argument &quot;findBy&quot; expects is an array, which all the examples only treat as a simple criteria (e.g. &quot;array('name' =&gt; 'billy')&quot; will select all the rows that have the value billy in their name column), which uses only the comparison operator.</p>
  <p>How can I use other operators such as</p>
  <pre><code>&gt;, &lt;, !=, IN, NOT IN, LIKE    
  </code></pre>
  <p>and etc. ?</p>