SQLite has now an experimental JSON1 extention to work with JSON fields. The functions too choose from look promising, but I don't get how to use them in the context of a query.
Suppose I created the following table:
sqlite> create table user(name,phone);
sqlite> insert into user values('oz', json_array(['+491765','+498973']));
The documentation shows how to use json_each
in a query, but all other functions lack some in context documentation.
Can someone with SQLite experience provide a few examples of how to use:
json_extract
json_set
Aucun commentaire:
Enregistrer un commentaire