title: Search multiples tables with different column names for a string
body: <p>i wanted to ask, how is it in sql to search multiple tables with different column names for a given string ? i know for 1 table it's: </p>
  
  <pre><code>select * from table where column like '%string%' 
  </code></pre>
  
  <p>... but for searching multiple tables (with different column names) for that same string ?
  i'm searching something like this: </p>
  
  <pre><code>select * from table1,table2 where table1.column and table2.column like '%string%'
  </code></pre>
  
  <p>so it would search in table1.column and table2.column for that specific string 
  is it possible ?</p>