On 9/4/15, Domingo Alvarez Duarte <sqlite-mail at dev.dadbiz.es> wrote: > select json_extract(json, '$.value') AS val > from json_tbl where val = 'the_value_1';
The latest trunk check-in now uses an index for this query -- D. Richard Hipp drh at sqlite.org
