经分析是数据多了引号导致的。在映射的时候应该使用 ->> 双键头的操作符将数据去引号:
->> | Return value from JSON column after evaluating path and unquoting the result; equivalent to JSON_UNQUOTE(JSON_EXTRACT()). |
-> | Return value from JSON column after evaluating path; equivalent to JSON_EXTRACT(). |
详见:
https://dev.mysql.com/doc/refman/5.7/en/json-function-reference.html