title: Split string in Mysql by colon and update a table record
body: <p>I have created a table (Table A), which has a column (Column A) which stores values like this
  Example:
  <code>ASUNMI:GI:PI:INP:EDM:20141001:NO34W:DERERTBYDAY14:NSW
  ASUNMI:GI:PI:HME:EDM:20140929:EO23M:WIERTNACAR:VICETC</code></p>
  
  <p>I need to split this string and place the data in different columns.</p>
  
  <pre><code>Example:
  
     Column2=ASUNMI
     Column3=GI
     Column4=PI
     Column5=INP
     Column6=EDM
  </code></pre>
  
  <p>I need to split the above string based on colons(:).the no of colons in each field could differ hence I cannot use the </p>
  
  <pre><code>substring_index(çolumn,':',-2) property
  </code></pre>
  
  <p>I need to then use this to update a table</p>