title: Compare MySQL dates?
body: <p>I have 2 columns, start and end.</p>
  
  <p>I need to filter the results to ensure that today's date is between start and end. The date is stored in MM/DD/YYYY syntax. e.g. 02/05/2011</p>
  
  <p>Can anyone show me how this is done please?</p>
  
  <pre><code>"SELECT * FROM albums WHERE active=1 AND ..."
  </code></pre>
  
  <p>Thanks.</p>