title: MySQL "between" clause not inclusive?
body: <p>If I run a query with a <code>between</code> clause, it seems to exclude the ending value.<br>
  For example:</p>
  
  <pre><code>select * from person where dob between '2011-01-01' and '2011-01-31'
  </code></pre>
  
  <p>This gets all results with <code>dob</code> from '2011-01-01' till '2011-01-30'; skipping records where <code>dob</code> is '2011-01-31'. Can anyone explain why this query behaves this way, and how I could modify it to include records where <code>dob</code> is '2011-01-31'? (without adding 1 to the ending date because its been selected by the users.)</p>