title: MySQL - SELECT WHERE date < X
body: <p>How do I do this in MySQL?</p>
  
  <pre><code> SELECT * FROM MyTable WHERE MyDateCol &lt; TODAY()
  </code></pre>
  
  <p>I googled a lot on the subject and didn't really find anything except "look in the MySQL date ref" which does not explain the above easily enough.</p>
  
  <p>I know I can do the following which is kinda indirect:</p>
  
  <pre><code>SELECT * FROM MyTable WHERE MyDateCol BETWEEN (0000-00-00) AND TODAY()
  </code></pre>