title: Drupal 7 - query using BETWEEN not working
body: <p>I have a query in Drupal 7 that is searching a custom table:</p>
  
  <pre><code>$query5 = "SELECT COUNT(reservation_id) as rcount5, reservation_id FROM {reservations} WHERE resource_id = :resource_id AND reservation_date = :reservation_date AND start_time BETWEEN :start_time AND :end_time";
  $result5 = db_query($query5, array(':resource_id' =&gt; $resource_id, ':reservation_date' =&gt; $reservation_date, ':start_time' =&gt; $start_time, ':end_time' =&gt; $end_time));
  </code></pre>
  
  <p>The query is not working because I believe that it is not recognizing the BETWEEN function properly and returning the end_time because it exists.  Is there a way to show drupal or the db api that this is a BETWEEN statement?  Thanks.</p>