title: mySQL query to search all tables within a database for a string?
body: <p><strong>Is there a mySQL query to search all tables within a database?</strong></p>
  
  <p>If not can you search all tables within a database from the mySQL workbench GUI?</p>
  
  <p>From phpmyadmin there's a search panel you can use to <strong>select all tables</strong> to search through.  I find this super effective since magento, the ecommerce package I'm working with has hundreds of tables and different product details are in different tables.</p>
  
  <p><img src="https://i.stack.imgur.com/zMXFY.png" alt="enter image description here"></p>