title: how to split a column into multiple columns in mysql
body: <p>I have column like this
  <pre><code>
  +--------------------------+
  | Marks                    |
  +--------------------------+
  |Maths-80,Phy-100,Che-99   |
  |Maths-90,Phy-60           | 
  |Phy-82,Che-65             |
  |Che-90                    |<br>
  |Maths-33,Phy-89,Che-65    |
  |Maths-50,Phy-43,Che-59    |
  +--------------------------+
  </pre></code>
  i just give 3 sample subjects but in realdata it maybe any number of subjects seperated by comma. for that i want to display the marks for each subject by split the marks column and display it in multiple columns like the below sample.  </p>
  
  <pre> <code>+-------------------------------------+-------------+------------+
  | Marks                  | Maths       | Phy         | Che        |
  +-------------------------------------+-------------+-------------+                               
  Maths-80,Phy-100,Che-99  | 80          |   100      |     99      |
  Maths-90,Phy-60          | 90          |   60       |     0       |
  Phy-82,Che-65            |  0          |   82       |     65      |
  Che-90                   | 90          |   0        |     0       |
  Maths-33,Phy-89,Che-65   | 33          |   89       |     65      |
  Maths-50,Phy-43,Che-59   | 50          |   43       |     59      |
  +-------------------------------------+-------------+-------------+  </code></pre>