Welcome Guest, Not a member yet? Register   Sign In
Build json_replace query
#7

(This post was last modified: 03-07-2022, 02:37 AM by alakian.)

@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!!
Reply


Messages In This Thread
Build json_replace query - by alakian - 03-06-2022, 12:46 AM
RE: Build json_replace query - by iRedds - 03-06-2022, 02:46 AM
RE: Build json_replace query - by alakian - 03-07-2022, 12:18 AM
RE: Build json_replace query - by iRedds - 03-07-2022, 12:28 AM
RE: Build json_replace query - by alakian - 03-07-2022, 01:12 AM
RE: Build json_replace query - by kenjis - 03-07-2022, 01:52 AM
RE: Build json_replace query - by alakian - 03-07-2022, 02:31 AM
RE: Build json_replace query - by alakian - 03-12-2022, 04:37 AM



Theme © iAndrew 2016 - Forum software by © MyBB