Hi,
http://blog.ulf-wendel.de/2013/mysql-5-7-sql-functions-for-json-udf/
This is not the exact solution for you query, but might help you better if
you add the libraries.
*thanks,*
*-- *Kishore Kumar Vaishnav
On Thu, 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
>
