Re: [Maria-discuss] How to get child data from a dynamic column

get the name3 column value, and after get the sub name value COLUMN_GET(COLUMN_GET(blob_fields, name3 as blob),sub-name1 AS char) must check if should be use as blob at name3 2014-06-15 4:53 GMT-03:00 Colin Charles :

Re-directing from the MariaDB Manager mailing list to maria-discuss where MariaDB Server discussions happen!

On 9 Jun 2014, at 22:26, Newton Bastardo López wrote:

...

I have a dynamic column with the next extructure:

blob_fields: name1: value1, name2: value2, name3: sub-name1: sub-value1, sub-name2: sub-value2

With COLUMN_GET(), how can I get those values childdren of 'name3'?

I was thinking use COLUMN_GET(blob_fields, COLUMN_GET(name3, sub-name1 as char)) as value, but It doenst work for me...

Thanks to much!

-- You received this message because you are subscribed to the Google Groups "MariaDB-Manager" group. To unsubscribe from this group and stop receiving emails from it, send an email to mariadbmanager+unsubscribe@googlegroups.com. For more options, visit https://groups.google.com/d/optout.

-- Colin Charles, Chief Evangelist, SkySQL - The MariaDB Company blog: http://bytebot.net/blog/| t: +6-012-204-3201 | Skype: colincharles

_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp

-- Roberto Spadim SPAEmpresarial Eng. Automação e Controle