like 中如何使用 in

[qingniao8]

t1
----------------
data_id

sdfsdf45656
rthtr565122
12354546565
56566444444
xcv32344344

t2
-----------
data

65122
44344

结果
------------
data data_id
65122 rthtr565122
44344 xcv32344344

--------------
请问这个查询应该如何写啊，谢谢！

[AcHerat]

select a.data,b.data_id
from t2 a,t1 b
where b.data_id like '%'+a.data+'%'

[GoAwayZ]

select * from t1 a, t2 b where charindex(a.data,b.data_id)>0

[bancxc]

charindex

[浪子-无悔]

模糊查询~

[-晴天]

create table t1(data_id varchar(20))
insert into t1 select 
'sdfsdf45656' union all select 
'rthtr565122' union all select 
'12354546565' union all select 
'56566444444' union all select 
'xcv32344344'
create table t2(data varchar(10))
insert into t2 select '65122' union all select 
'44344'
go
select a.*,b.* from t1 a inner join t2 b on a.data_id like '%'+b.data+'%'
/*
data_id              data
-------------------- ----------
rthtr565122          65122
xcv32344344          44344

(2 行受影响)

*/
go
drop table t1,t2

[chuanzhang5687]

select a.*,b.* from t1 a inner join t2 b on a.data_id like '%'+b.data+'%'

[qingniao8]

速度好快啊～～～结贴～

[yubofighting]

select data,data_id=(select data_id from t1 where data_id like '%'+t2.data+'%') from t2