title: Split column string into multiple columns strings
body: <p>I have a entry in the table that is a string which is delimited by semicolons. Is possible to split the string into separate columns? I've been looking online and at stackoverflow and I couldn't find one that would do the splitting into columns. </p>
  
  <p>The entry in the table looks something like this (anything in brackets [] is not actually in my table. Just there to make things clearer):</p>
  
  <pre><code>sysinfo [column]
  miscInfo ; vendor: aaa ; bootr: bbb; revision: ccc; model: ddd [string a]
  miscInfo ; vendor: aaa ; bootr: bbb; revision: ccc; model: ddd [string b]
  ...
  </code></pre>
  
  <p>There are a little over one million entries with the string that looks like this. Is it possible in mySQL so that the query returns the following</p>
  
  <pre><code>  miscInfo,   Vendor,   Bootr,  Revision ,  Model [columns]
  miscInfo_a, vendor_a,  bootr_a, revision_a, model_a
  miscInfo_b, vendor_b,  bootr_b, revision_b, model_b
  ...
  </code></pre>
  
  <p>for all of the rows in the table, where the comma indicates a new column?</p>
  
  <p><strong>Edit:</strong> </p>
  
  <p>Here's some input and output as Bohemian requested.</p>
  
  <pre><code>sysinfo [column]
  Modem &lt;&lt;HW_REV: 04; VENDOR: Arris ; BOOTR: 6.xx; SW_REV: 5.2.xxC; MODEL: TM602G&gt;&gt;
  
  &lt;&lt;HW_REV: 1; VENDOR: Motorola ; BOOTR: 216; SW_REV: 2.4.1.5; MODEL: SB5101&gt;&gt;
  
  Thomson DOCSIS Cable Modem &lt;&lt;HW_REV: 4.0; VENDOR: Thomson; BOOTR: 2.1.6d; SW_REV: ST52.01.02; MODEL: DCM425&gt;&gt;
  </code></pre>
  
  <p>Some can be longer entries but they all have similar format. Here is what I would like the output to be:</p>
  
  <pre><code>miscInfo, vendor, bootr, revision, model [columns]
      04,   Arris,  6.xx, 5.2.xxC, TM602G
      1, Motorola, 216, 2.4.1.5, SB5101
    4.0, Thomson, 2.1.6d, ST52.01.02, DCM425
  </code></pre>