title: use WHERE clause for offset in MySQL LIMIT
body: <p>I want to perform a query, ordered across the entire result set, but with an offset for a specific row (based on a column value).</p>
  
  <p>Basically:</p>
  
  <pre><code>SELECT * FROM users
  ORDER BY reputation
  LIMIT 3 OFFSET (WHERE users.id = 6)-1
  </code></pre>
  
  <p>Is there any way to perform a query like that?</p>
  
  <p>For a table like:</p>
  
  <pre><code>USERS
  id   reputation
  1   33
  2   34
  3   40
  4   53
  5   45
  6   44
  </code></pre>
  
  <p>Should return</p>
  
  <pre><code>id   reputation
  3    40
  6    44
  5    45
  </code></pre>
  
  <p>So, I'm getting user with id=6, and the two users with the closest amount of reputation (one that is higher and one that is lower).</p>