mysql JSON类型取值

location字段是json类型location json not null示例数据内容:{city: {code: 330100, name: 杭州市}, province: {code: 33000, name: 浙江省}}要查杭州市的 select * from life_car_sources where location-\$.city.code330100;$query-whereRaw(sprintf(location-\$.city.code%6s, $code));对于images json数组[https://t9.baidu.com/it/u871642577,2885145290fm173app49fJPEG?w312h208s87026CA50E1329CA04A941A103001002, https://t9.baidu.com/it/u1413090630,1422875006fm218app92fJPEG?w121h75s152042B1685316C6381041B50300C001]取首个图片DB::raw(images-$[0] as images)