insert the split values into the same table.

Question

Hi.

i am having table as Attendance_TB . in this the coursename saved like "GRE+GMAT+TOFEL". I want to enter the attendance individualy to all the coursenames. some student already having like that but not 3 courses.

ex. in 1st row : 1836  |GRE+GMAT+TOFEL |june  |2015  |

in 2nd row :      1836  |GRE                             |june  |2015  |

in 3rd row :       1836  |GMAT                          |june  |2015  |

like this.

 

But TOFEL is not inserted. so i want to split that course which is in 1st row and only insert TOFEL coursename. can any one help me...