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日

悬赏问题

  • ¥15 腾讯云如何建立同一个项目中物模型之间的联系
  • ¥30 VMware 云桌面水印如何添加
  • ¥15 用ns3仿真出5G核心网网元
  • ¥15 matlab答疑 关于海上风电的爬坡事件检测
  • ¥88 python部署量化回测异常问题
  • ¥30 酬劳2w元求合作写文章
  • ¥15 在现有系统基础上增加功能
  • ¥15 远程桌面文档内容复制粘贴,格式会变化
  • ¥15 这种微信登录授权 谁可以做啊
  • ¥15 请问我该如何添加自己的数据去运行蚁群算法代码