How to insert attribute to json string in mysql?

Question

I had a json string in mysql database like following.

{"name":"Georg","position":"Manager"}

I need to add another attribute like "date_of_birth":"1989-06-08"

score 2 · Answer 1 · answered Jul 21 '19 at 18:12

2

You can also use JSON_INSERT function:

SELECT JSON_INSERT(@`json`, '$.date_of_birth', '1989-06-08');

answered Jul 21 '19 at 18:12

wchiquito

score 0 · Answer 2 · answered Jul 20 '19 at 18:07

You could try using a replace() function on the json string

select  REPLACE ( column_name, "}",  ', "date_of_birth":"1989-06-08"}')
from my_table

or for update the value in you table

UPDATE my_table
SET column_name = REPLACE ( column_name, "}",  ', "date_of_birth":"1989-06-08"}')

2 Answers2