80sand 2022-09-13 09:15 采纳率: 87.9%
浏览 39
已结题

mysql替换字符串中某个对应的字段值


{"erp_store_stock":[{"title":"[江中]健胃消食片","bus_no":"1146","ware_id":"001538","batch_no":"ACC22061688021","id_no":"4","stall_no":"1146","stock":"1","price":9.9,"price_original":9.9,"price_unit":"9.90"}],"delivery_time":"","article_id":0,"inviter_id":"","is_prescription":false,"medication_id":0,"disease_name":"","chain_shop_settings":{"status":"1","coupon_type":"1","withdraw_type":[1,2,3],"settlement_fee_type":"1","settlement_fee_custom":"0.6","entry_type":"1"},"chain_shop_info":{"id":164,"shop_id":1,"name":"朴西佳苑店","lng":"107.22808400","lat":"34.35041100","status":1,"logo":"image/1/2022/08/40f9dee03fe0970a9d67b16885dcda27.jpg","shop_number":"1146","contact_settings":{"telephone":"13772641194","province":"陕西省","province_code":"610000","city":"宝鸡市","city_code":"610300","area":"渭滨区","area_code":"610302","detail":"陕西省宝鸡市高新开发区高新四路9号院13幢1层3号","lng":"107.228084","lat":"34.350411"},"business_settings":{"time_type":"2","time_type_custom":{"start":"07:30","end":"22:00"},"proof":["image/1/2022/06/ea2ebf5332b9858084b7bf179a588a0c.png","image/1/2022/06/d65087cc7c711789cb7dcc9fcd8d4865.jpg","image/1/2022/06/fc65576e716863a851f86601458aec89.jpg","image/1/2022/05/ff6c1c7a37e4661f1e01f518276dd4c7.jpg"],"proof_show":"1","remark":""}}}

在表aa中。上面是字段bb的值。如何才能更改其中batch_no=123 和 id_no=2 用mysql

  • 写回答

3条回答 默认 最新

  • 天蝎彬 2022-09-13 17:13
    关注

    1、首先这个字段是json格式的,mysql表中这个字段类型应该设置成json,但是现在你们设计的是字符串,毕竟字符串万能的
    2、使用json_set 函数(字段是json格式,或者json格式的字符串都行)
    UPDATE aa set bb = json_set(bb,'$.batch_no','123','$.id_no','2')

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

问题事件

  • 系统已结题 10月5日
  • 已采纳回答 9月27日
  • 创建了问题 9月13日

悬赏问题

  • ¥20 机器学习能否像多层线性模型一样处理嵌套数据
  • ¥20 西门子S7-Graph,S7-300,梯形图
  • ¥50 用易语言http 访问不了网页
  • ¥50 safari浏览器fetch提交数据后数据丢失问题
  • ¥15 matlab不知道怎么改,求解答!!
  • ¥15 永磁直线电机的电流环pi调不出来
  • ¥15 用stata实现聚类的代码
  • ¥15 请问paddlehub能支持移动端开发吗?在Android studio上该如何部署?
  • ¥20 docker里部署springboot项目,访问不到扬声器
  • ¥15 netty整合springboot之后自动重连失效