sql json查询

如果json中键值对的键名以字母开头

select * from tbUniversalPrintRecord where JSON_VALUE(UniversalVarsJson,'$.PN') = 'A243900003'

如果json中键值对的键名不以字母开头

select * from tbUniversalPrintRecord where JSON_VALUE(UniversalVarsJson,'$."2D"') = 'A3IH00003;/;A3CH2;2349;2000'