title: Query MySql Database for entries with 'Birthday' date field within 30 days from current date
body: <p>I am trying to write a PHP script that queries a MySql database and returns the entries for which the Birthday date field is within the next 30 days.  I am able to do this, but I need to exclude the year from the Birthday date when making the query.  For example, if today's date is 7/10/2013, and the birthday in question is 7/13/1991, obviously these two dates are more than 30 days apart, but if we exclude the year, they are only 3 days apart.  Making this a valid Birthday to return.</p>
  
  <p>The Birthday field is stored as a DATE in the MySql database.</p>
  
  <p>The query I have made so far:</p>
  
  <pre><code>$results = mysql_query("SELECT * FROM Club WHERE Birthday &lt; DATE_SUB(NOW(), INTERVAL 30 DAY)");
  </code></pre>
  
  <p>What can I do to modify this query to not take the year into account?</p>