Hello !
That's what json_extract does !
json_extract('[2,3,4,5,6]', '$[3]'); --> returns 5;
Cheers !
> Fri Sep 11 2015 8:40:36 pm CEST CEST from "Nelson, Erik - 2"
><erik.l.nelson at bankofamerica.com> Subject: Re: [sqlite] Feedback request:
>JSON support in SQLite
>
> Richard Hipp wrote on Friday, September 11, 2015 11:59 AM
>
>
>>Draft documentation for the current design of JSON support in SQLite
>> can be seen on-line at
>>
>> https://www.sqlite.org/draft/json1.html
>>
> This looks really good!
>
> With the understanding that json_extract() already has the functionality,
>I've found that the json_array_* functions can be complemented by a
>json_array_index() function that returns the value at a given index into the
>array.
>
> Erik
>
> ----------------------------------------------------------------------
> This message, and any attachments, is for the intended recipient(s) only,
>may contain information that is privileged, confidential and/or proprietary
>and subject to important terms and conditions available at
>http://www.bankofamerica.com/emaildisclaimer. If you are not the intended
>recipient, please delete this message.
> _______________________________________________
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
>
>
?
