学生党，刚接触json,
有一表mytable, id--int2, detail--json
id detail
1 {"city":{"Location":"shanghai", “PC”:021}, "country":"China"}
2 {"city":{"Location":"Beijing", “PC”:010}, "country":"China"}
……
select id, json_each_text(detail) as b where b like '%Beijing%'
报错…………
难道json_each_text()函数不是把json转换为成对的text的函数吗

不需要这函数～直接查行