Extra a string value and update the string value in Postgres SQL

Asked Mar 25 '20 at 15:33

Active Mar 25 '20 at 15:35

Viewed 28 times

There is a column in one of my tables which contains the value like

{"firstname":"aaa","secondname:"bbb","lastname":"ccc","age":"18","Address:"xxxxxxxxxxxxxx"}

I am in need of SQL query to extract the value secondname (here the value will be bbb)
and I also need a update query to set the second value as empty the output will be like

{"firstname":"aaa","secondname:"","lastname":"ccc","age":"18","Address:"xxxxxxxxxxxxxx"}

edited Mar 25 '20 at 15:35

asked Mar 25 '20 at 15:33

Arun K

Does this answer your question? [How do I modify fields inside the new PostgreSQL JSON datatype?](https://stackoverflow.com/questions/18209625/how-do-i-modify-fields-inside-the-new-postgresql-json-datatype) – Tim Biegeleisen Mar 25 '20 at 15:35
In my tables the data type for my column as text. – Arun K Mar 26 '20 at 19:06

0 Answers0