how to cast this data as json in mysql?

Question

I have data in one of my table columns as like {x:1,y:2} . I wanted to cast the data to json like {"x":"1","y":"2"}

I tried to use JSON_QUOTE and cast as JSON with no success.

Can you add more sample data to your question? – Tim Biegeleisen Apr 05 '23 at 06:57 — Tim Biegeleisen, Apr 05 '23 at 06:57
Because that is not JSON structure. – Justinas Apr 05 '23 at 06:57 — Justinas, Apr 05 '23 at 06:57
all of data is the same. – Pvria Ansari Apr 05 '23 at 07:34 — Pvria Ansari, Apr 05 '23 at 07:34
@TimBiegeleisen Does it matter? – Pvria Ansari Apr 07 '23 at 20:11 — Pvria Ansari, Apr 07 '23 at 20:11

Pvria Ansari · Accepted Answer · 2023-04-05T12:53:10.757

-1

I used this Replace section for the answer:

REPLACE(CONCAT("{\"",REPLACE(REPLACE(REPLACE(REPLACE(form_field.settings,"\n",","),"=",":") ,",","\",\""),":","\":\""),"\"}"),",\"\"","")

then I completed that Like:

JSON_EXTRACT(CAST(REPLACE(CONCAT("{\"",REPLACE(REPLACE(REPLACE(REPLACE(form_field.settings,"\n",","),"=",":") ,",","\",\""),":","\":\""),"\"}"),",\"\"","") AS JSON),"$.accessname" )

edited Apr 05 '23 at 12:53

answered Apr 05 '23 at 07:35

Pvria Ansari

406
4
20

how to cast this data as json in mysql?

1 Answers1