可以参考下：

CREATE TABLE aaa(
id varchar(128) NOT NULL,
lists varchar(3500) constraint json_check check (lists is json)
);

INSERT INTO aaa values('1','[1,2]');
INSERT INTO aaa values('1','["1","2","3"]');
commit;

select * from aaa WHERE json_value(lists, '$[0]')='1';