title: mysql match a year withing datetime field
body: <p>I am wondering if this is possible, in my database table, I have a datetime field, I wanting to query that table and pull in all the rows that have a posted date of 2011, however my date posted column is dateTime, so the form looks like this, </p>
  
  <p>2011-06-12 00:00:00</p>
  
  <p>How can I  query the table to return all 2011 rows?</p>