Shilpa
Published in : 2022-03-31
//My code snippetSELECT JSON_EXTRACT('{"id":"A0001","name":"shilpa"}', '$.name');
I want to extract key-value from Json stored in my database table.
But above statement should return shilpa, In my case it is returning as “shilpa” (Returning value with double quotes)
On the UI side, I am using angular and I have to remove/replace double quotes with empty strings all the time! I am using Mysql 8.0 and SQLite DB v3.0
Is there a way to ignore double quotes which are appending in JSON_EXTRACT?
Join our community and get the chance to solve your code issues & share your opinion with us
Sign up Now
Mohamed Atef Date : 2022-03-31
Best answers
51
Best answers
51
I believe you can remove the qoutes in this way
and you can use foreach to extract the object and rebuild it
OR
you can use foreach only to get the key of the array like
Good luck