如何将此数据转换为mysql中的json ?

Question

我有数据在我的表列之一，如{x:1,y:2}。我想将数据转换为json{"x":"1","y":"2"}

我尝试使用JSON_QUOTE并将其转换为JSON，但没有成功。

Answer 1

我使用了这个Replace部分作为答案:

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

然后我完成了Like:

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