List:General Discussion« Previous MessageNext Message »
From:Andrew Moore Date:March 21 2014 5:09pm
Subject:Re: Decode Json in MySQL query
View as plain text  
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.sk@stripped>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 <mdykman@stripped> 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 <abvk@stripped> 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.sk@stripped>
> > 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
> >  - mdykman@stripped
> >
> >  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
> >
> >
>

Thread
Decode Json in MySQL querySukhjinder K. Narula20 Mar 2014
  • Re: Decode Json in MySQL queryKarr Abgarian20 Mar 2014
    • Re: Decode Json in MySQL queryMichael Dykman20 Mar 2014
      • Re: Decode Json in MySQL querySukhjinder K. Narula21 Mar 2014
        • Re: Decode Json in MySQL queryAndrew Moore21 Mar 2014
  • Re: Decode Json in MySQL queryKishore Vaishnav20 Mar 2014