使用 CONCAT 拼接% 和 字段进行模糊查询
select hg.FLONGNAMEGROUP_L2 ,hg.FCONTROLUNITID , items.FNAME_L2 as 项目名称 ,items.Fid as 项目id , items.CFTARGETCOMPANYIDS from T_BD_AssistantHG hg inner join CT_CUS_Items items on items.fid=hg.CFITEMSID where CFITEMSID is not null and items.CFTARGETCOMPANYIDS not like CONCAT(CONCAT('%', hg.FCONTROLUNITID ),'%')