title: How to select dates with same day and month (ignoring year) using firebird
body: <p>I have a database where users stores their birthday. y-m-d, and I'm trying to get every user that has the same birthday; the year can be different between each user.</p>
  
  <p>So how do I turn this to a working script:</p>
  
  <pre><code>SELECT username FROM table_name WHERE birthday='$birthday'
  </code></pre>
  
  <p><code>$birthday</code> gets its data from a form, where the inputs is example: <code>2002-02-02</code>. And if users have this birthday it should echo it out. But the problem is that it checks with the year, and I'm trying to only get month and day, not year.</p>
  
  <p>I have tried with <code>EXTRACT(MONTH FROM ...)</code> but didn't get it to work. What am I missing?</p>