title: is it possible to select a specific row index from a mysql select result set?
body: <p>if I run a SELECT query that returns 10 rows, is there a way to select the 2nd item in the result set right in the SELECT statement (effectively getting a single row result)?</p>
  
  <p>psedudo code:</p>
  
  <p>SELECT id from MYTABLE where MYTABLE.foo = 0 and RESULT_INDEX = 2;</p>
  
  <p>this would return the 2nd item from a multi item result set.</p>