You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I want use json1 in sql.js, I test some sql snippet in online demo
create table user (name text,phone JSON );
insert into user (name, phone) values("oz",'{"cell":"+491765", "home":"+498973"}');
select user.phone from user where user.name=='oz';
select json_extract(user.phone, '$.cell') from user;