I have created a postgres specific sql with which I can succesfully search a json string value for a the label element. The json would look like this and is stored as a string in the db:

I am trying to update a JSON value stored in an MS SQL table, so here is the situation. We have a table named SupportPlans with a column named PlanValue. We need to update the MedicationTasks based on the following criteria: Find the task that has the following values:

I’m trying to use SQL in DBeaver to query a column containing some JSON values.

I have a json in the below format in a table in column item_details and I am trying to get the rows with category = drawing-room. I have tried the below approach but getting null in result. Requesting to please suggest. Thanks!

I have a JSON which is as given below and it’s stored in a column