title: Use table name in MySQL SELECT "AS"
body: <p>I use the table name to build a nested array when I evaluate my MySQL SELECT JOIN result in PHP. However, when working with AS for calculated columns, I can't seem to set the table name as intended (to simplify, I am trying without a JOIN in this example, but the problem is the same):</p>
  
  <pre><code>SELECT `field1`, `field2`, "Test" AS `Table`.`field3` FROM `Test`;
  </code></pre>
  
  <p>This throws an error.</p>
  
  <p>How can I indicate in the SQL, which table I want to associate field3 with?</p>
  
  <p>(resulting in the table name in <code>$pdoStatement-&gt;getColumnMeta()</code> being "Table")</p>