title: find entries to the left and right of a certain entry in a mysql table in a single query
body: <p>Let's say I have a table in a database like <a href="http://sqlfiddle.com/#!2/e1aaf/11" rel="nofollow">this table</a>. Let's say that I want to get the entries on the left and right of the entry whose the primary key is equal to 5 (or any other primary key). So in our case, I want to get the entries whose primary key is equal to 4 and 6 respectively. What is the SQL query that will give me such result? Can you guys translate the SQL query into a <a href="http://book.cakephp.org/1.3/en/The-Manual/Developing-with-CakePHP/Models.html#find-all" rel="nofollow">find('all')</a> CakePHP query?</p>
  
  <p>Thank you</p>
  
  <p><strong>NOTE: The ids are not necessarily contiguous, meaning, they do not necessarily follow the 1, 2, 3, 4, 5, 6, 7, 8 sequence. I can have something like 1, 5, 13, 44, 66, 123, etc</strong> </p>