-------------------------------------------------------------------------------- js.db create table if not exists model ( id integer primary key autoincrement, name varchar(100), json varchar(4000) ); -- insert into model (name, json) values ('Test', '{"color": "#ffffff", "yaw": 0}'); select * from model; select * from model where upper(name) like '%' order by id limit 10 offset 0; --------------------------------------------------------------------------------