MySQL JSON 数组查询

100人浏览 2025-01-17 00:28:56

数据表中images字段内容

[“/images/ea/eca11ba6f3e4c99c25b125df8ffef5.jpe”, “/images/8c/c62149fdda71229315d67d13eabae3.png”, “/images/31/e9776ba0aa5a9e9a47f7579f0111c4.png”]

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”