'MySQL JSON_MERGE / REPLACE. How to actually update values and not merge

What I WANT to do, but I guess it's somewhow not possible:

I have JSON data in a column for saving translations. for example column description value: {"de": "hi wie gehts?", "en": "hi, how are you?"}

Now I want to update only the "en" property. I know it's possible with JSON_REPLACE but it has a weird syntax where I have to generate SQL code first to make this happen.

What I am looking for is the possibility to just send {"en": "hi, how are you!?"} and then it should keep the "de" property and only updating the "en" property.

There is the JSON_MERGE function, but this does not what I am looking for, but apart from that, that's the syntax I like to use.

Is there a workaround with some nested mysql functions or so?

mysqlsqljsonmariadb


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions