title: MySQL select Current_timestamp between
body: <p>I have a list of users in MySQL and on subscription the timestamp is set in the data base using the CURRENT_TIMESTAMP.</p>
  
  <p>Now I want to do a select from this table where the subscribe date is between day X and day Y
  I tried several queries but somehow they all turn up empty. </p>
  
  <p>Here is my last version</p>
  
  <pre><code>SELECT * 
  FROM users 
  WHERE subscribe_date BETWEEN '2013-10-07'AND '2013-13-10'
  </code></pre>
  
  <p>As I know for sure this date: 2013-10-08 14:38:49
  is in the subscribe_data field It should turn up somehow</p>
  
  <p>What is the best way to do this?</p>
  
  <p>Maybe good to know my 'subscribe_date' column has type 'timestamp' and is auto filled with 'CURRENT_TIMESTAMP'</p>
  
  <p>Here is the data in this table:</p>
  
  <pre><code>+----+-----------+---------------------+
  | id | firstname | subscribe_date      |
  +----+-----------+---------------------+
  | 20 | Peter     | 2013-10-01 14:37:17 |
  | 21 | Jack      | 2013-10-08 14:38:49 |
  | 22 | Andrew    | 2013-10-10 14:41:03 |
  | 23 | Margret   | 2013-10-14 14:42:46 |
  +----+-----------+---------------------+
  </code></pre>