Build json_replace query

@iRedds : Thanks for your reply.

My Json is:

Code:

{
    "socialnetwork": {
        "twitter": "tw-u"
    },
    "information": {
        "country": "Cuba",
        "state": "Sancti Spiritus"
    },
    "settings": {
        "social-enable": "1"
    }
}

And I test with your approach:

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.