title: splitting mysql column into two columns with delimiter
body: <p>I have a DB where one column is a person's job information in the form of: "name of employer/job title" e.g. "Harvard University/Professor"  I want to split this into two columns  an employer column and a title column.</p>
  
  <p>Is there a quick way to do this in MySQL or do I need to write a script to do this.</p>