title: Unknown table 'table_name' in information_schema
body: <p>I want to <code>show index</code> from each table that has <code>table_schema='foo'</code> (database name).</p>
  
  <pre><code>mysql&gt; show index from table_name from information_schema.tables where table_schema='foo';
  ERROR 1109 (42S02): Unknown table 'table_name' in information_schema
  </code></pre>
  
  <p>From the error, I see that the query treats <code>'table_name'</code> as a table in <code>information_schema</code>.  How do I rewrite the query to treat <code>'table_name'</code> as a column in <code>information_schema.tables</code>?</p>