赞
踩
select count(*)
from table_name
where JSON_CONTAINS(json-> '$.filed1', '"xxx"')
or JSON_CONTAINS(json-> '$.filed2', '"xxx"')
select name from data_asset_measure where JSON_EXTRACT(json, '$.filed1') = "name";
select CAST(TRIM(BOTH '"' FROM JSON_EXTRACT(json, '$.xx')) as DECIMAL) as xxx,
from table_name;
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。