title: Select mySQL based only on month and year
body: <p>I have a column in my mySQL DB that has some rows. One of this row is a DATE, like this: <code>2012-02-01</code></p>
  
  <p>What I want to achieve is to do a SELECT with PHP based only on the year and month.</p>
  
  <p>The logic of the SELECT will be the following:</p>
  
  <pre><code>$q="SELECT * FROM projects WHERE Date="SELECT HERE THE SPECIFIC YEAR AND MONTH"";
  </code></pre>
  
  <p>The specific month and year will be be passed from a <code>$_POST</code> variable, like this <code>$_POST['period']="2012-02";</code></p>
  
  <p>How can I do it?</p>