title: MYSQL - Split Data Into Multiple Rows
body: <p>I have imported some data using an application that collects info from IMDB and transfers them into a MYSQL database.</p>
  
  <p>It seems the fields have not been normalized and contained many values within 1 field</p>
  
  <p>For example:</p>
  
  <pre><code>Table Movie
  MovieID          Movie_Title           Written_By
  1                Movie1                Person1, Person2   
  2                Movie2                Person3  
  3                Movie3                Person4, Person2, Person6  
  </code></pre>
  
  <p>Is there way to separate the values and have them inserted into another table to something like this and without any duplicates?</p>
  
  <pre><code>Table Writers
  WriterID         Written_By                MovieId      
  1                Person1                   1
  2                Person2                   1
  3                Person3                   3
  </code></pre>
  
  <p>I did some googling and found that I am supposed to process this data using PHP.
  But I have no knowledge with PHP at all.</p>
  
  <p>Is there anyway to convert this data using just MYSQL? </p>