Hello, I would like to know if there is a way to decode the json string stored in one of the fields as text without using triggers or stored procedures. What I want to do is is within the query, I would like to get one row per element within the json string. For example: the json string is as follow:
and after query, I want result as: Name Age Abc 20 Xyz 18
Would this be possible, I greatly appreciate any help regarding this matter.
Many Thanks, Sukhjinder
Mar 20
Karr Abgarian Re: Decode Json in MySQL query
Mar 20, 2014; 11:59
Karr Abgarian
Re: Decode Json in MySQL query
Mar 20
Kishore Vaishnav Re: Decode Json in MySQL query
Mar 20, 2014; 11:57
Kishore Vaishnav
Re: Decode Json in MySQL query
Mar 20
Michael Dykman Re: Decode Json in MySQL query
Mar 20, 2014; 15:05
Michael Dykman
Re: Decode Json in MySQL query
Mar 21
Sukhjinder K. Narula Re: Decode Json in MySQL query
Mar 21, 2014; 08:27
Sukhjinder K. Narula
Re: Decode Json in MySQL query
Mar 21
Andrew Moore Re: Decode Json in MySQL query
Mar 21, 2014; 17:09
Andrew Moore
Re: Decode Json in MySQL query
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!