title: Compare only day and month with date field in mysql
body: <p>How to compare only day and month with date field in mysql?
  For example, I've a date in one table: <code>2014-07-10</code></p>
  
  <p>Similarly, another date <code>2000-07-10</code> in another table.
  I want to compare only day and month is equal on date field.</p>
  
  <p>I tried this format. But I can't get the answer</p>
  
  <pre><code>select *
  from table
  where STR_TO_DATE(field,'%m-%d') = STR_TO_DATE('2000-07-10','%m-%d')
  and id = "1"
  </code></pre>