title: Restructuring data in SQL
body: <p>My results currently return the following:</p>
  
  <pre><code>+----+-------+-------+-------+
  | ID | item1 | item2 | item3 |
  +----+-------+-------+-------+
  |  1 |     1 |     0 |     1 |
  |  2 |     0 |     1 |     1 |
  |  3 |     1 |     1 |     1 |
  +----+-------+-------+-------+
  </code></pre>
  
  <p>I would like them to be:</p>
  
  <pre><code>+-----------+
  | ID | item |
  +-----------+
  | 1 | item1 |
  | 1 | item3 |
  | 2 | item2 |
  | 2 | item3 |
  | 3 | item1 |
  | 3 | item2 |
  | 3 | item3 |
  +-----------+
  </code></pre>
  
  <p>Is restructuring the data like this possible?</p>
  
  <p>Any help is much appreciated!</p>