In SurrealDB SQL, How do you find and update value in array of objects
Given the data below how do I write a SurrealDB SQL query that selects the record where the address array has an object with the key of ‘door_no’ and the value of ’16’ and update its postcode value to ‘newpostcode’