php - Separate the comma values in single row in sql query -

this question has answer here:

• can mysql split column? 7 answers

i have table structure

 id     flim_name     flim_actor_name  1      diwalie       shah rukh khan,kajol,varun dhawan  2      mersal        vijay, samantha,kajol 

i need convert table in structure

id     flim_name     actor_name       heroin_name  director_name 1       diwalie      shah rukh khan     kajol       varun dhawan 2       mersal       vijay              samantha       kajol 

i need sql query solve

use implode this

ex.

$arr = array(shah rukh khan,kajol,varun dhawan); echo implode(" ",$arr); echo implode(" ",$arr)."<br>"; echo implode("+",$arr)."<br>"; echo implode("-",$arr)."<br>";  echo implode("x",$arr); 

ouput:

shah rukh khan kajol varun dhawan shah rukh khan+kajol+varun dhawan shah rukh khan-kajol-varun dhawan shah rukh khanxkajolxvarun dhawan