May also be of interest;
http://www.slideshare.net/blueskarlsson/using-json-with-mariadb-and-mysql
On Fri, Mar 21, 2014 at 12:27 PM, Sukhjinder K. Narula
<narula...@gmail.com>wrote:
> 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
> >
> >
>
