title: MySQL select from all tables with a column name
body: <p>Let's say I query this:</p>
  <pre class="lang-sql prettyprint-override"><code>SELECT TABLE_NAME
  FROM INFORMATION_SCHEMA.COLUMNS
  WHERE COLUMN_NAME like 'coduser';
  </code></pre>
  <p>it returns a list of tables which contains the column &quot;coduser&quot;:</p>
  <pre><code>users
  messages
  passwords
  photos
  </code></pre>
  <p>It's a 20+ items list.</p>
  <p>I need to search on those tables all occurrences where &quot;coduser&quot; is equal to &quot;5OEWP1BPSV&quot;.</p>
  <pre class="lang-sql prettyprint-override"><code>SELECT * FROM tablenamehere WHERE coduser = &quot;5OEWP1BPSV&quot;;
  </code></pre>
  <p>but I'm not using anything other than MySQL to do this.</p>
  <p>Basically just search all tables where there is a column called &quot;coduser&quot; and coduser = &quot;5OEWP1BPSV&quot;.</p>