SQLITE_ENABLE_JSON1
Posted: Thu Jan 28, 2016 9:31 am
Sample sql with JSON
Related issue : link
More info : http://www.sqlite.org/json1.html
Code: Select all
select * from
json_tree((select INFOVALUE from INFOTABLE_V1 where INFONAME='NAV_TREE_STATUS'), '$')
where json_tree.id != 0
More info : http://www.sqlite.org/json1.html