select b.* from tableB b, (select * from table where aid = ~id~ limit 1,30) a where instr(b.title,a.name)
select * from tableB b where exists (select 1 from (select * from table where aid = ~id~ limit 1,30) a where instr(b.title,a.name))
select * from table A INNER JOIN (select * from table where aid = ~id~ limit 1,30) B ON INSTR(B.title,A.F1)>0OR select * from table A,(select * from table where aid = ~id~ limit 1,30) B WHERE A.title like CONCAT('%',B.F1,'%')
select b.*
from tableB b, (select * from table where aid = ~id~ limit 1,30) a
where instr(b.title,a.name)
where exists (select 1 from (select * from table where aid = ~id~ limit 1,30) a where instr(b.title,a.name))
select * from table A INNER JOIN
(select * from table where aid = ~id~ limit 1,30) B
ON INSTR(B.title,A.F1)>0OR
select * from table A,(select * from table where aid = ~id~ limit 1,30) B
WHERE
A.title like CONCAT('%',B.F1,'%')