title: Select date range on mysql timestamp
body: <p>I am trying the following but get no results:</p>
  
  <pre><code>SELECT *
  FROM users_test
  WHERE dateadded &gt;= UNIX_TIMESTAMP('2012-02-01 00:00:00') 
  AND dateadded &lt;  UNIX_TIMESTAMP('2012-11-01 00:00:00');
  </code></pre>
  
  <p>Yet I know there are columns with dates within that range e.g.</p>
  
  <pre><code>2012-05-11 17:10:08
  </code></pre>
  
  <p>Is there a better way to do this?</p>
  
  <p>Eventually I want to search multiple parameters, albeit not at the same time, like today, yesterday, last week, last month etc and also a date range and month range</p>