title: MySQL - select data from database between two dates
body: <p>I have saved the dates of a user's registration as a datetime, so that's for instance <strong>2011-12-06 10:45:36</strong>. I have run this query and I expected this item - <strong>2011-12-06 10:45:36</strong> - will be selected:</p>
  
  <pre><code>SELECT `users`.* FROM `users` WHERE created_at &gt;= '2011-12-01' AND
  created_at &lt;= '2011-12-06'
  </code></pre>
  
  <p>But is not. Exist any elegant way, how to select this item? As a first idea that I got was like <code>2011-12-06 + 1</code>, but this doesn't looks very nice.</p>