title: sql new column by delimiter with order ID
body: <p>Hi this maybe a simple one but I need help specifically for MYsql </p>
  
  <p>I have the data in one column lets call the column WORK 1,2,3,5,2 (these values are sometimes longer and shorter or more values are present e.g 12,15,11,15,16,143)</p>
  
  <p>I need these to be put into 1 new column for each delimiter and have an ID for the order presented. e.g output</p>
  
  <p><a href="https://i.stack.imgur.com/BFFrk.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BFFrk.png" alt="enter image description here"></a></p>