select a.thiscol, b.thatcol, c.thiscol from table a, table2 b, table3 c, table4 d where a.thiscol like '%this%' or b.thatcol like '%that%'
That way you can build big query. There are other ways to achieve what you are doing. Like keeping keywords in a separate table with a reference to the...