title: MYSQL Where function
body: <p>I have a table made up of <code>podcasts</code> I have <em>done</em>, <em>song</em>, <em>artist</em>, <em>title mix number date</em> and <em>etc</em>. I am using a class with individual methods to display them in separate </p>
  
  <p>My question is, how do you get <code>desc</code> rows?  Like this <em><code>(mix_number is an int)</code></em></p>
  
  <pre><code> select mix_name, date where mix_number = MAX(mix_number) limit 1 //1st query
  
   select mix_name, date where mix_number = MAX(mix_number - 1)//this would be the second query
  
   select mix_name, date where mix_number = MAX(mix_number - 2)//3rd query
  </code></pre>
  
  <p>I dont want to hardcode the <code>where clause</code> with a number because I want it to update as I add more.</p>
  
  <p>I am really asking is <em><code>MAX(mix_number)</code></em> or <em><code>MAX(mix_number-1)</code></em> proper?  I cant get it to work this way</p>
  
  <p>I hope this is understandable. I have other queries in the methods but an answer here will fix them too.</p>