select tem.utsTempCode,json_extract(tem.utsTempCode, "$.view")
from adtemplate tem
where tem.templateId=101077
select tem.utsTempCode,json_extract(tem.utsTempCode, "$.view")
from adtemplate tem
where tem.templateId=101077
and json_extract(tem.utsTempCode, "$.view") like '%10959%'
json字段
于 2021-04-27 09:20:17 首次发布