title: curdate() till rest of the month mysql
body: <p>I'm trying to retrieve data between today and the rest of this month. </p>
  
  <pre><code>select * from table where date between curdate() and endmonth();
  </code></pre>
  
  <p>My experience with mysql dates/times is pretty bad. </p>