Invalid JSON path expression. The error is around character position

Question

I insert json data to mySql database like this:

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

Now, I try to update social-enable value using JSON_REPLACED method like this:

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

In action I see this error:

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

How do can I fix this problem?

wchiquito · Accepted Answer · 2022-03-08 20:30:56Z

1

JSON Path Syntax

... Names of keys must be double-quoted strings or valid ECMAScript identifiers (see Identifier Names and Identifiers, in the ECMAScript Language Specification). ...

Try:

... JSON_REPLACE(information, '$.settings."social-enable"', '0') ...

UPDATE

Try:

$builder->where('id', 2)->set('information', "JSON_REPLACE(information, '$.settings.\"social-enable\"', '0')", false);

edited Mar 8, 2022 at 20:30

answered Mar 7, 2022 at 20:24

wchiquito

16.6k2 gold badges37 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

LarakBell Over a year ago

Right, I add "social-enable" in my query like your solution but I see new syntax this error in my code: syntax error, unexpected 'social' (T_STRING), expecting ')'

Collectives™ on Stack Overflow

Invalid JSON path expression. The error is around character position

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related