I have a column (comments) in a table which contains a string in the form |A : some value | B: some value | C : some value |
along with some extra text. What I need is to extract the value of A,B,C and add it to the same table under new column A,B,C respectively.
我正在尝试编写一个SQL存储过程,该存储过程可以在同一张表中添加如上所述的新列A,B,C。我该如何写呢?
数据样本图:
我是新来的。