title: How to query sql with active record for dates between specified times
body: <p>I have a database that I want to pull only certain rows that have dates in specified ranges. I'm not sure how to do this properly in active record. Right now it looks like I'm running a standard mysql query inside of an active record query. I hope this gives you the idea of what I'm looking for. </p>
  
  <p>I would also like to be able to get rows with anything before today, including today and 3 days in the future. </p>
  
  <pre><code>$query = $this-&gt;db-&gt;query("SELECT * FROM 'topics_list' . 'topic date' WHERE DATE(order_datetime) BETWEEN '2012-10-01' AND '2012-10-3'");
  </code></pre>