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

I need to build JSON_REPLACE query like this:

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.
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