MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table mytable (js json);
insert into mytable values 
	('{"1": true, "2": false, "3": true}'),
	('{"foo": true, "bar": false}');
select * from mytable


js


{"1": true, "2": false, "3": true}

{"bar": false, "foo": true}


select sum(x.val = 'true') cnt_true, sum(x.val = 'false') cnt_false
from mytable t
cross join json_table(
	js -> '$.*',
	'$[*]' 
	columns (val varchar(5) path '$')
) x


cnt_true
cnt_false


3
2