mysql like 子查询

[JeremyChenX]

现在有两张表。 表A和表B。

A表，有个字段叫做：ID。

B表，有个字段叫做：current_address。

现在想做个”like 子查询“，即

select * from b where current_address like '% 表A.ID %'

[张蒙炬]

select a.*,b.* from A a,B b where b.current_address like concat('%',a.ID,'%');

[听雨停了]

两个表连接，条件就写b表的current_address like '% 表A.ID %'就ok了啊

[JeremyChenX]

但怎么写都不对啊。 有大神嘛 ~ 求指点

[有点意思！]

select B.current_address from A表 inner join B表 on B.current_address like concat('%',A表.id,'%');

[有点意思！]

select distinct(B.current_address) from B表 inner join A表 on B.current_address like concat('%',A表.id,'%');

[蜕变之痛]

select b.* from a,b where b.current_address = concat(‘/artices/’,a.id)

[csdn_castiel]

select * from b where current_address like concat('/artices/','表A.ID%') union all select * from b where current_address like concat('/其他路径/','表A.ID%') union all select * from b where current_address like concat('/其他路径2/','表A.ID%') 。。。 删掉like左边百分号，这样可以用到索引