title: MySQL: Select values based on current month and day
body: <p>I have a MySQL table called <strong>history</strong> that includes a column called <strong>month</strong>: January, February, March, etc. and a column called <strong>day_num</strong> containing day numbers from 1 to 31. </p>
  
  <p>I need to be able to select a month and a day from the two corresponding columns, based on the current month and day. </p>
  
  <p>I know it's a rather embarrasingly basic question, but - how do I do that?</p>
  
  <pre><code>SELECT month, day_num FROM history WHERE ??????? ORDER BY RAND() LIMIT 1; 
  </code></pre>
  
  <p>Would appreciate a bit of advice from a knowledgeable person. </p>