Replace value in column which each cell contains muliple values

[Adam Bateman]

Hi,

Im trying to edit my database that contains data from a tracker. I wish to delete the values for the odometer, but the value is in a column named `attributes` which contains mutiple data in each cell like below

{"operator":23410,"odometer":4.9654157716276E7,"io83":1265,"io87":51129600,"distance":3.28,"totalDistance":688005.33,"fuel":999873.5,"hours":61446060,"Sleep Mode":"Awake","Mobile Network":"o2","FMC Battery":"3.924","Car Battery":"15.027000000000001","Speed":12,"Fuel Tank (%)":25,"Engine RPM":727,"Total Fuel used (l)":126.5}

I've tried update but can't seem to select the value "odometer" in the column `attributes`

Any help appreciate