select id, name, interests from user where interests->'$.likes'->>'$[0]' = 'reading';
Bookmark · 27 February 2022, 12:03 JSON improvements in SQLite 3.38.0 select id, name, interests from user where interests->'$.likes'->>'$[0]' = 'reading'; jsontoolsnb