MySQL JSON 数组查询
数据表中images字段内容
- [“/images/ea/eca11ba6f3e4c99c25b125df8ffef5.jpe”, “/images/8c/c62149fdda71229315d67d13eabae3.png”, “/images/31/e9776ba0aa5a9e9a47f7579f0111c4.png”]
查询SQL语句
- SELECT JSON_UNQUOTE(json_extract(`images`,"$[0]")),json_extract(`images`,"$[0]"),images->>'$[0]',images->'$[0]' FROM `table_name`
查询结果
查询 | 结果 |
JSON_UNQUOTE(json_extract(images,”$[0]”)) | /images/ea/eca11ba6f3e4c99c25b125df8ffef5.jpe |
json_extract(images,”$[0]”) | /images/ea/eca11ba6f3e4c99c25b125df8ffef5.jpe |
images->>’$[0]’ | /images/ea/eca11ba6f3e4c99c25b125df8ffef5.jpe |
images->’$[0]’ | “/images/ea/eca11ba6f3e4c99c25b125df8ffef5.jpe” |
