如何将数据库中的一列转换成多列

UPDATE Sheet1
SET c1 = '1'
WHERE c like '%1%'

UPDATE Sheet1
SET c2 = '1'
WHERE c like '%2%'

UPDATE Sheet1
SET c3 = '3'
WHERE c like '%3%'