I have a column called params which is a json data,
{
"Sender": "Sean Simmons",
"Event": "Annual meeting",
"EventDate": "2023-12-25",
"Message": "Attendance is "MANDATORY"!"
}
Trying to use JSON_VALUE on the column returns NULL, so i removed the quotes and then it worked, but is there anyway how i can handle this from the database to escape the double quotes of the value and to return it as it is?
Is there anything similar that i can use like the function escape_double_quotes to fix this issue?