title: using 'AND' with COUNT(*)
body: <p>I would like to get the total number of entries, upon 2 or more conditions.
  Yet is seems as if mysql is ignoring the 'AND' clause in the query.</p>
  
  <p><strong><em>edit</em></strong>:
  I want to get number of calls made by user with id=97, while the date is between starttime and stoptime, and prefix is like *us*</p>
  
  <p>Example:</p>
  
  <pre><code>select count(*)
    from calls
    where id = 97 
    and starttime &gt;= '2012-06-11'
    and stoptime &gt;= '2012-06-12'
    and prefix like '%us%'
  </code></pre>
  
  <p>This gives me total amount of calls from id=97, while ignoring the rest of the conditions</p>