select t3.name from tb_stat t1, tb_stat t2, tb_stat t3 where t1.name <> t2.name and instr(t2.name,t1.name)>0 and t3.name like concat('%',t1.name,'%') group by t3.name本回答被提问者采纳
第2个回答 2010-06-23
例如表名叫table: select a.name from table a inner join table b on a.name <> b.name and (a.name like '%'+ b.name + '%' or b.name like '%'+ a.name + '%' ) order by a.name