title: How to parse this LONGTEXT string field in MySQL
body: <p>I need to extract the following fields into a new table. Any ideas whether I can do this exclusively with a query or I need to use PHP as well?</p>
  
  <h3>Current table structure</h3>
  
  <pre><code>USERID  USEREXPERINCE
  1       a:4:{i:0;s:20:"business development";i:1;s:6:"design";i:2;s:9:"marketing";i:3;s:15:"press relations";}
  </code></pre>
  
  <h3>Required table structure</h3>
  
  <pre><code>USERID             USEREXPERINCE
  1                  business development
  1                  design
  1                  marketing
  1                  press relations
  2                  web development
  2                  design
  3                  marketing
  3                  business development
  </code></pre>
  
  <p>Thanks.</p>