title: can mysql find the year value of a unix timestamp?
body: <p>im storing the dates that entries were posted on in the db using a standard unix timestamp. </p>
  
  <p>is it possible, using only a mysql query (no php logic), to select entries that were posted in a certain year?</p>
  
  <p>id like to avoid retrieving ALL entries and then using php to filter on year value. i could store the year in a separate field of course, just curious about this</p>