select * from 库名.表名 where JSON_EXTRACT ( 表名.字段,‘$.json属性值’ ) like 限定条件
select * from acquarium.r_datasource_config where JSON_EXTRACT( r_datasource_config.attribute,’$.host’) like ‘%228%’;
select * from 库名.表名 where JSON_EXTRACT ( 表名.字段,‘$.json属性值’ ) like 限定条件
select * from acquarium.r_datasource_config where JSON_EXTRACT( r_datasource_config.attribute,’$.host’) like ‘%228%’;