结果

JSON_UNQUOTE(json_extract(images,”$[0]”))

/images/ea/eca11ba6f3e4c99c25b125df8ffef5.jpe

php数组查询sqlMySQL JSON 数组查询 RESTful API

json_extract(images,”$[0]”)

/images/ea/eca11ba6f3e4c99c25b125df8ffef5.jpe

images->>’$[0]’

/images/ea/eca11ba6f3e4c99c25b125df8ffef5.jpe

images->’$[0]’

“/images/ea/eca11ba6f3e4c99c25b125df8ffef5.jpe”