title: Separating query values on MySQL
body: <p>Is there anyway to separate values within a single record and create a new record with this separate information. Is this possible with a query? For example, a value in a table is as following:</p>
  
  <pre><code>        Single COL
  level1Data.level2Data.level3Data 
  level1Data.level2Data.level3Data 
  level1Data.level2Data.level3Data
  </code></pre>
  
  <p>converted to:</p>
  
  <pre><code> level1Col   |   level2Col   |  level3Col
               |               |
  Level1Data   |  Level2Data   |  Level3Data
  Level1Data   |  Level2Data   |  Level3Data
  Level1Data   |  Level2Data   |  Level3Data
  </code></pre>