title: How to select a specific part of a SQL query result?
body: <p>I have a MySQL table with a million rows. The result of my query needs to contain 100 rows and has to be ordered by date.</p>
  
  <p>I would now like to add a clause to the query that makes it possible to tell the database to "start the result with the row that comes after the row with the id '5'", for example. My result would therefore include the rows with the ids 4, 3, 2, 6, 8, ...</p>
  
  <p>Are you, dear reader, the sought database wizard who could put me out of my misery? ;)</p>
  
  <p>Query:</p>
  
  <pre><code>SELECT id, type, content, date
  FROM my_table
  WHERE type = 'FI'
  ORDER BY date ASC
  LIMIT 100;
  </code></pre>
  
  <p>Result:</p>
  
  <pre><code>| id | type | content  | date       |
  |----|------|----------|------------|
  | 7  | FI   | ContentR | 2014-01-01 |
  | 9  | FI   | ContentS | 2014-01-13 |
  | 1  | FI   | ContentT | 2014-02-09 |
  | 5  | FI   | ContentU | 2014-03-27 |
  | 4  | FI   | ContentV | 2014-03-30 | ---|
  | 3  | FI   | ContentW | 2014-04-01 |    |
  | 2  | FI   | ContentX | 2014-06-10 |    |- The result I want
  | 6  | FI   | ContentY | 2014-09-03 |    |
  | 8  | FI   | ContentZ | 2014-12-09 |    |
   ...                                  ---|
  </code></pre>