sqlite-json1

So, here is a first example of how to use json_extract. First, the data is a inserted in a bit different way: insert into user (name, phone) values(“oz”, json(‘{“cell”:”+491765″, “home”:”+498973″}’)); Now, we can select all the users phone numbers as in normal sql: sqlite> select user.phone from user where user.name==’oz’; {“cell”:”+491765″,”home”:”+498973″} sqlite> But, what if … Read more