List:General Discussion« Previous MessageNext Message »
From:Michael Dykman Date:March 20 2014 7:05pm
Subject:Re: Decode Json in MySQL query
View as plain text  
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.
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