List:General Discussion« Previous MessageNext Message »
From:Sukhjinder K. Narula Date:March 21 2014 12:27pm
Subject:Re: Decode Json in MySQL query
View as plain text  
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