title: Convert a column of set values to a column of individual values in MySQL
body: <p>I have inherited a table where one column is a comma-separated list of primary keys for a different table:</p>
  
  <pre>
  id | other_ids | value
  ---|-----------|-------
  1  | a,b,c     | 100
  2  | d,e       | 200
  3  | f,g       | 3000
  </pre>
  
  <p>I would like to convert this table to one where each <code>other_id</code> gets a column of its own:</p>
  
  <pre>
  id | other_id
  ---|---------
  1  | a
  1  | b
  1  | c
  2  | d
  2  | e
  3  | f
  3  | g
  </pre>
  
  <p>However, I cannot think of a way to do this?</p>
  
  <p>The table is > 10 GB in size, so I would like to do this inside the database, if possible.</p>