mysql - 将列拆分为二进制矩阵

Question

基本上我有一个这样的专栏:

+----------------+
| Marks          |
+----------------+
|Maths,Phy,Che   |
|Maths,Phy       | 
|Phy,Che         |
|Che             |
|Maths,Phy,Che   |
|Maths,Phy,Che   |
+----------------+

我也想成为这样的人

+-------------------------+-------+------+------+
| marks                   | Maths | Phy  | Che  |
+-------------------------+-------+------+------+
| Maths,Phy,Che           | 1     | 1    | 1   |
| Maths,Phy               | 1     | 1    | 0   |
| Phy,Che                 | 0     | 1    | 1   |
| Che                     | 0     | 0    | 1   |
| Maths,Phy,Che           | 1     | 1    | 1   |
| Maths,Phy,Che           | 1     | 1    | 1   |
+-------------------------+-------+------+------+

我试图使用此答案中发布的子字符串( how to split a column into multiple columns in mysql )

但我无法让它按照我想要的方式工作

Answer 1

可以使用类似值结果的列

select marks
      , (marks like '%Maths%') as Maths
      , (marks like '%Phy%') as Phy
      , (marks like '%Che%') as Che
from my table