Build json_replace query

link管理

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

相关文章推荐

想发财的黄瓜 · 比例尺为 1:5 的欧洲国际地质图 ...· 3 月前 ·

想出家的毛豆 · 如何将列表中的所有数字转换为相应的负数？-腾 ...· 3 月前 ·

干练的甜瓜 · JS条件运算符（?:）详解· 4 月前 ·

聪明伶俐的肉夹馍 · ContrstrainLayout的动画之C ...· 1 年前 ·

健身的咖啡豆 · 上传 Upload - Ant Design· 1 年前 ·

    Code:
   
     UPDATE table_name
     
     SET subjectcombination = JSON_REPLACE(subjectcombination, '$.subjectcombination[0].college', 'ABC')
     
     WHERE id = 10;

How do can I build json_replace in CI4?!
thanks.

    Code:
   
     $builder = $this->db->table('users');
     
     $builder->where('id', 2)->set('information', "JSON_REPLACE(information, '$.settings[0].social-enable', '0')", false) ;
     
     $builder->update();

In action I see this error:

    Code:
   
     Invalid JSON path expression. The error is around character position 27.

(03-06-2022, 02:46 AM) iRedds Wrote: $.settings[0].social-enable = {"settings" : [ { "social-enable" : 1} ]}

@ iRedds : I change to this but I see same error:

Code:


     {
     

     "socialnetwork": [{
     

     "twitter": "tw-u"
     

     "information": [{
     

     "country": "Cuba",
     

     "state": "Sancti Spiritus"
     

     "settings": [{
     

     "social-enable": "1"
     

     @
     
      alakian
     
     Why don't you check the SQL that the Query Builder create?
     

     Or why don't you use
     
      $db->query()
     
     ?
     

     
      https://codeigniter4.github.io/userguide...ar-queries
     
     
      ci-phpunit-test
     
     |
     
      CodeIgniter Testing Guide
     
     |
     
      CodeIgniter 3 to 4 Upgrade Helper
     
     @
     
      
       
        
         kenjis
        
       
      
     
     : I think my problem not related to the query method. I'v created my query use $db->query() like this:
     

     
      
       Code:
      
      
       
        $this->db->query('UPDATE users SET information = JSON_REPLACE(information, "$.settings[0].social-enable", "0")');
       
      
     
     

     In action I saw same error!!