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
