title: MySQL select before after row
body: <p>This is the example table:</p>
  <pre><code>Column             | 1st record | 2nd record | 3rd record | 4th record | etc&lt;br /&gt;
  id (primary)       | 1          | 5          | 8          | 12         | etc&lt;br /&gt;
  name               | name 1     | name 2     | name 3     | name 4     | etc&lt;br /&gt;
  date               | date 1     | date 2     | date 3     | date 4     | etc&lt;br /&gt;
  callValue (unique) | val1       | val2       | val3       | val4       | etc
  </code></pre>
  <p>I select one row that is the data to show (for example: row with callValue: val3). But I cannot find a solution for this:<br />
  I need to select previous and next row. So, in this example, I need to get data from rows callValue: val4 and callValue: val2, or id: 5 and id: 12.</p>
  <p>It cannot be done with <code>id</code>=<code>id</code>+-1 because <code>id</code> doesn't have to be continuous because of deleting rows.</p>