title: mySQL SELECT upcoming birthdays
body: <p>I'm trying to write a query to select users of a database whose birthdays are in the next 7 days.</p>
  
  <p>I've done a lot of research but I can't come up with a working solution. </p>
  
  <p>The birthday field is stored as a varchar eg '04/16/93' is there any way to work with this?</p>
  
  <p>This is what I have so far:</p>
  
  <pre><code>SELECT * 
  FROM   `PERSONS` 
  WHERE  `BIRTHDAY` &gt; DATEADD(DAY, -7, GETDATE()) 
  </code></pre>
  
  <p>I should have made it more clear, I'm trying to find birthdays not dates of birth. So i'm just looking for days and months not years.</p>