title: mysql get first and last row for group data
body: <p>i have a event table,</p>
  
  <pre><code>| id | title  | date       |
  | 1  | party  | 2011-02-02 |
  | 2  | party  | 2011-02-03 |
  | 3  | party  | 2011-02-04 |
  | 4  | party  | 2011-02-05 |
  | 5  | brunch | 2011-05-20 |
  | 6  | brunch | 2011-05-21 |
  | 7  | brunch | 2011-05-22 |
  | 8  | brunch | 2011-05-23 |
  </code></pre>
  
  <p>i want to transfer data this structure</p>
  
  <pre><code>| id | title  | start      | finish     |
  | 1  | party  | 2011-02-02 | 2011-02-05 |
  | 2  | brunch | 2011-05-20 | 2011-05-23 |
  </code></pre>
  
  <p>what is best way ?</p>