mysql如下,
select land_property
from tb_land_info
where 1 = 1
and json_contains(land_property, '3');
select land_property
from tb_land_info
where 1 = 1
and json_contains(land_property, json_array(3,2,1));
mysql对json的支持,
mysql如下,
select land_property
from tb_land_info
where 1 = 1
and json_contains(land_property, '3');
select land_property
from tb_land_info
where 1 = 1
and json_contains(land_property, json_array(3,2,1));
mysql对json的支持,