Many Thanks for the kind replies.
I have decoded in my code but just wondering in case I missed any solution
to decode via query.
On Thu, Mar 20, 2014 at 3:05 PM, Michael Dykman <mdyk...@gmail.com> wrote:
> Short answer, no. There is nothing in MySQL to facilitate this. In
> general, storing structured data as a blob (JSON, CSV, XML-fragment,
> etc..) is an anti-pattern in a relational environment. There are
> NoSQL solutions that provide the facility: Mongo comes to mind; there
> are some others, I am sure.
>
>
>
> On Thu, Mar 20, 2014 at 2:59 PM, Karr Abgarian <a...@apple.com> wrote:
> > Hi, you probably want to perform this conversion on your client. There
> are JSON parser libraries available for Java, PHP and the like. Cheers,
> Karr
> >
> > On Mar 20, 2014, at 11:35 AM, Sukhjinder K. Narula <narula...@gmail.com>
> wrote:
> >
> >> 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:
> >>
> >> [
> >> {
> >> "name" : "Abc",
> >> "age" : "20"
> >> },
> >> {
> >> "name" : "Xyz",
> >> "age" : "18"
> >> }
> >> ]
> >>
> >> 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
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe: http://lists.mysql.com/mysql
> >
>
>
>
> --
> - michael dykman
> - mdyk...@gmail.com
>
> May the Source be with you.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql
>
>
