I have a database field file_name
which stores the data as json encoded format which is a two dimensional array.
[{"211":"Rice.jpg"},{"212":"Cadbury_5_star_Chocolate.jpg"},{"213":"Strawberry.jpg"},{"214":"mung-dal-photo.jpg"}]
Is there any way to update the key value using where condition in SQL?