Welcome toVigges Developer Community-Open, Learning,Share
Ask a Question
Welcome To Ask or Share your Answers For Others

Categories

mysq如何解析json字符串

0 votes
148 views
in Technique[技术] by (71.8m points)

mysq如何解析json字符串

现在表里面有params字段,text类型的，存了一个很大的json字符串，json中 "time_z" 出现过N次，我想在不写存储过程，不建中间表的前提下，写一个sql把time_z字段对应的值全部提取出来，如何做到？


与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

如果你使用的是 mysql 5.7 以上,可以使用 mysql 提供的 JSON_ 开头的函数来处理
如果不是,那就只能当字符串处理了..


与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…
Welcome to Vigges Developer Community for programmer and developer-Open, Learning and Share

Just Browsing Browsing

2.1m questions

2.1m answers

63 comments

56.6k users

Most popular tags

Snow Theme by Q2A Market
Powered by Question2Answer
...