title: What is the opposite of GROUP_CONCAT in MySQL?
body: <p>I seem to come against this problem a lot, where I have data that's formatted like this:</p>
  
  <pre><code>+----+----------------------+
  | id | colors               |
  +----+----------------------+
  | 1  | Red,Green,Blue       |
  | 2  | Orangered,Periwinkle |
  +----+----------------------+
  </code></pre>
  
  <p>but I want it formatted like this:</p>
  
  <pre><code>+----+------------+
  | id | colors     |
  +----+------------+
  | 1  | Red        |
  | 1  | Green      |
  | 1  | Blue       |
  | 2  | Orangered  |
  | 2  | Periwinkle |
  +----+------------+
  </code></pre>
  
  <p>Is there a good way to do this?  What is this kind of operation even called?</p>