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>
>> 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
>> Many Thanks,
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql
- michael dykman
May the Source be with you.