decode json data into string using query

Question

Hi i am using phpmyadmin mysql

In one of my database table i have a column contact_email and the value is stored as below

contact_email
["[email protected]"]

Which is Json encoded data , I am trying to convert that encoded data into string using query

I tried qith JSON_extract but it gave error.

Output what i need is

Any help appreciated.

Anand Choudhary · Accepted Answer · 2018-04-26 08:39:16Z

1

Simple use something like that

var obj = jQuery.parseJSON( '{ "name": "John" }' );
alert( obj.name === "John" );

answered Apr 26, 2018 at 8:33

Anand Choudhary

5655 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1