例如：{"order id":"2023022818173","title":"Modified Senning Operation in the Treatment of Transposition of The Great Arteries","author":"Kevin Clarke; Gavin Lucas;","journal":"Clinical and Translational Medicine","journal_discription":"Clinical and Translational Medicine"}

json中的key带有空格

我写的sql语句：

select o.Id,o.No

,o.jsondata

,JSON_VALUE(o.jsondata, '$.journal')  AS journal

,JSON_VALUE(o.jsondata, '$.index date')  AS indexdate

from Order as o

错误提示：JSON 路径格式不正确。位置 7 中存在非预期的字符 " "。

网上找了一遍没发现解决方案，大佬看看有没有其它写法呢