title: Select From all tables - MySQL
body: <p>I have a mySQL database called <code>listDB</code> that contain several tables with column name <code>Product</code> etc. I want to <code>SELECT</code> from all tables where Product Like %XYZ%, and display the search result in a separate table.</p>
  
  <p>I tried this:</p>
  
  <pre><code>SELECT * FROM * WHERE Product LIKE %XYZ%
  </code></pre>
  
  <p>But it is not working. What is the right query for this purpose?</p>