Sample sql with JSON

Code: Select all
select * from 
json_tree((select INFOVALUE from INFOTABLE_V1 where INFONAME='NAV_TREE_STATUS'), '$')
where json_tree.id != 0
json.png
(9.62 KiB) Downloaded 483 times


Related issue : link
More info : http://www.sqlite.org/json1.html