title: Getting data between two date strings in MySQL
body: <p>I have been recording Twitter data for a project I'm working on the date information is saved as <code>Thu, 14 Jul 2011 06:21:48 +0000</code> in a string field.</p>
  
  <p>How do I select data that falls between two dated using mySQL? I can get data larger than a value or smaller than a value but not between to values.</p>
  
  <p>The data for example is:</p>
  
  <pre><code>Thu, 14 Jul 2011 06:21:48 +0000
  Thu, 14 Jul 2011 12:18:21 +0000
  Thu, 14 Jul 2011 18:48:00 +0000
  Thu, 14 Jul 2011 23:48:02 +0000
  Fri, 15 Jul 2011 06:48:10 +0000
  Fri, 15 Jul 2011 12:48:00 +0000
  Fri, 15 Jul 2011 18:43:32 +0000
  Fri, 15 Jul 2011 23:44:08 +0000
  Sat, 16 Jul 2011 06:47:08 +0000
  Sat, 16 Jul 2011 12:46:49 +0000
  Sat, 16 Jul 2011 18:45:41 +0000
  Sat, 16 Jul 2011 23:41:27 +0000
  </code></pre>
  
  <p>My SQL string is:</p>
  
  <pre><code>SELECT * 
  FROM twitter 
  WHERE SUBSTR(twitter_date, 6, 11) &gt;= '2011-06-15' 
  AND SUBSTR(twitter_date, 6, 11) &lt;= '2011-06-21'
  </code></pre>
  
  <p>I've tried <code>BETWEEN</code> statements as well but no luck.</p>
  
  <p>Any help will be appreciated!</p>