在mysql中分隔单元格中的值

xj3cbfub  于 2021-06-15  发布在  Mysql
关注(0)|答案(0)|浏览(294)

我有下表,我想用select查询分隔单元格中的值。
单元格中的值介于 " 又是我想要的分栏在哪里 : table是这样的:

  1. _______________________________________________________________________________________________________________________
  2. |john|data3w43|data2 |"{""4"":""6935593"",""6756756"":"""",""1"":""hfghh"",""3"":""89899"",""5"":"""",""2"":""2""}"|
  3. _______________________________________________________________________________________________________________________
  4. |joh3|data3423|data102 |"{""43"":""69741354534593"",""62"":""34"",""1"":"""",""3"":""hgfhg"",""5"":"""",""2"":""2""}"|
  5. _______________________________________________________________________________________________________________________
  6. |j3hn|data3434|data32 |"{""4"":""6974135593"",""6"":"""",""1"":""hfgh"",""3"":""hfgh"",""5"":""hfgh6"",""2"":""2""}"|
  7. _______________________________________________________________________________________________________________________

我想要一张有如下选择的table:

  1. ______________________________________________________________________________________________________________________
  2. |john|data3w43|data2 |4 |6935593 |6756756| |1|hfghh|3|89899|5 | |2|2|
  3. _______________________________________________________________________________________________________________________
  4. |joh3|data3423|data102 |43|69741354534593|62 |34|1| |3|hgfhg|5 | |2|2|
  5. _______________________________________________________________________________________________________________________
  6. |j3hn|data3434|data32 |4 |6974135593 |6 | |1|hfgh |3|hfgh |5 |hfgh6|2|2|
  7. _______________________________________________________________________________________________________________________

有人能帮我吗?

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题