mysql一列拆成多列_如何在mysql中将一列拆分为多列

I have column like this+--------------------------+

| Marks |

+--------------------------+

|Maths-80,Phy-100,Che-99 |

|Maths-90,Phy-60 |

|Phy-82,Che-65 |

|Che-90 |

|Maths-33,Phy-89,Che-65 |

|Maths-50,Phy-43,Che-59 |

+--------------------------+

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.

+-------------------------------------+-------------+------------+

| Marks | Maths | Phy | Che |

+-------------------------------------+-------------+-------