MySql searching in JSON object with array with objects on specific property value
I have a table 'sometable' with a JSON field named 'jsonval', which contains a JSON object with the property 'programs' that contains an array of objects with the property 'id' I want to search for records that contain jsonval.programs.id =…