title: split string in mysql query
body: <p>i have field that has records like '1:23,2:23' and '2:43'</p>
  
  <p>is there any way to split string into 1,23,2,23 (separate values, so i can work with them independently) 
   using mysql query.
  for example add them to another table like </p>
  
  <pre><code> row1:   1 | 23
   row2:   2 | 43 
  </code></pre>
  
  <p>the string can contain more pairs of keys/ values</p>