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"

wchiquito · Accepted Answer · 2019-07-21 18:12:14Z

2

You can also use JSON_INSERT function:

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

answered Jul 21, 2019 at 18:12

wchiquito

16.6k2 gold badges37 silver badges46 bronze badges

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

Comments

ScaisEdge · Accepted Answer · 2019-07-20 18:07:06Z

1

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"}')

answered Jul 20, 2019 at 18:07

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges