title: Easiest way to search in all columns of multiple tables?
body: <p>I have many tables:</p>
  
  <pre><code>d_customers
  d_customers
  d_news
  d_pages
  d_products
  d_projects
  d_sms 
  </code></pre>
  
  <p>and I want to create a search form to search for any word typed in it in all columns of all tables... But when write SQL code I see that it's long and confusing... Can any one tell me the right way to do this?</p>
  
  <pre><code>'SELECT * FROM d_customers,d_customers,d_news,d_pages,d_products,d_projects,d_sms
  WHERE ' . $nc_make . 'LIKE .....
  AND LIKE.... AND LIKE.....  AND LIKE.....  AND LIKE.....  '
  </code></pre>
  
  <p>i want to search into all coulmns in all tables by LIKE word...if i search for google word i want to select all coumns in all tables where all columns like google</p>