How to replace one value in a table?

Question

MySQL

Good afternoon, this is the question:
I have a database, the database has a "Questionnaires" table, the "Questionnaires" table has a "JSON" column that stores the questionnaire data, links are incorrectly specified in this JSON column, What query can replace a pure url without affecting other data?

Answer 1

https://database.guide/json_set-insert-or-update-v...