select top 1 cxljdzj_cpsm AS cpms,cxljdzj_cpname AS cpname,wuliu_cp FROM cxljdzj_cp where
CHARINDEX(',2,',','+wuliu_cp+',')>0
wuliu_cp 字段数据内容一般是“ 1,3,4,11 ”;
然后查询wuliu_cp内容存在2这个ID的数据
select top 1 cxljdzj_cpsm AS cpms,cxljdzj_cpname AS cpname,wuliu_cp FROM cxljdzj_cp where
CHARINDEX(',2,',','+wuliu_cp+',')>0
wuliu_cp 字段数据内容一般是“ 1,3,4,11 ”;
然后查询wuliu_cp内容存在2这个ID的数据