34,837
社区成员




--测试数据
if not object_id(N'Tempdb..#T') is null
drop table #T
Go
Create table #T([id] int,[uid] int,[xianlu] int,[pbqd] nvarchar(37))
Insert #T
select 1,1,1,N'1,2,3,4,5,6' union all
select 2,1,3,N'10,11,12,13' union all
select 3,1,2,N'14,12,16,19' union all
select 4,1,4,N'13,21,23,24,46,65' union all
select 5,1,6,N'23,30,22,38,47,' union all
select 6,2,1,N'70,71,72,73,6' union all
select 7,2,7,N'74,75,76,77,78,79' union all
select 8,2,11,N'81,82,83,84,85' union all
select 9,2,8,N'86,87,88,89' union all
select 10,2,9,N'90,91,92,93,94'
Go
--测试数据结束
SELECT a.*
FROM #T a
JOIN #T b
ON b.uid <> a.uid
AND b.xianlu = a.xianlu
AND a.pbqd LIKE '%6%'
AND b.pbqd LIKE '%6%';
SELECT a.id,
a.uid,
a.xianlu,
a.pbqd
FROM zd_base a
WHERE
find_in_set('幸福站', a.pbqd)
AND EXISTS(
SELECT 1
FROM zd_base b
WHERE a.uid != b.uid
AND a.xianlu = b.xianlu
)
显示出来的, 跟你比较的根本不是一个东西。select a.id,a.uid,a.xianlu,a.pbqd,b.id,b.uid,b.xianlu,b.pbqd from zd_base a,zd_base b where a.uid!=b.uid and a.xianlu=b.xianlu and find_in_set('幸福站',a.pbqd) group by a.id having count(1)>0