json added to MySQL

Question

How to add new elements to json variables in mySQL

thus: value = ['123'] Do this: Value = ['123','456']

Answer 1

JSON_ARRAY_APPEND() ; Function

SET @Value = '["123"]';
SET @Value = JSON_ARRAY_APPEND(@Value, '$', '456');
SELECT @Value;

@Value
["123", "456"]

violin