title: How to specify a relative date in MySQL?
body: <p>I already know how to, for instance, get tomorrow's date in a query in SQL; either use <code>ADDDATE(CURDATE(),1)</code> or <code>DATE_ADD(CURDATE(), INTERVAL 1 DAYS)</code> (or something like that).</p>
  
  <p>But how would I get a date that is a bit more eccentric, for example the 10th of next month?</p>