title: SQL query to select all records from the last 5 years
body: <p>I have a table called <em>recruits</em> that has columns including <em>first</em>, <em>last</em>, and <em>class</em>. The <em>first</em> and <em>last</em> columns are collectively the primary keys and represent a recruit's first and last names, respectively. The <em>class</em> column is the year in which the recruit has committed. Note that there can be multiple recruits in the same class, ie have the same <em>class</em> value.</p>
  
  <p>I want to display all records from the most recent class--whatever it might be--as well as the ones from the four previous classes/years. I don't really want to hard-code a range of specific years because I would have manually change it whenever a new class/year comes along.</p>
  
  <p>Any help is appreciated. Let me know if my description is too vague.</p>
  
  <p>EDIT: I'm just using MySQL/Apache friends</p>