select t1.id from t1, t2, where t2.id = 1 and t1.name like '% t2.name %'
select t1.id from t1, t2 where t2.id = 1 and t1.name like concat('%', t2.name, '%')