title: how to select record in given dates
body: <p>i have a table named rooms_booked and field is:</p>
  
  <p>id, room_id, check_in_date, check_out_date.</p>
  
  <p>how can i search those record which is booked between to  given dates</p>
  
  <p>say i want to search those record which is booked between 16-04-2011 to 19-04-2011.</p>
  
  <p>thanks in advance  </p>