title: Select by Month of a field
body: <p>How can I get records from my table using month/year? I have a table like this:</p>
  
  <pre><code>Name - varchar
  DueDate -datetime
  Status -boll
  </code></pre>
  
  <p><code>DueDate</code> is project due date, I want record corresponding to month/year, not full date, I mean record for specific month.</p>
  
  <p>How can I do this in mysql?</p>