title: MySql SELECT AS - Append all field names
body: <p>I'd like to do something like this:</p>
  
  <pre><code>SELECT table.id AS prefix_id, table.name AS prefix_name
  </code></pre>
  
  <p>... and have the prefix added dynamically to all field names rather than selecting them all manually (ie <code>SELECT table.* AS prefix_*</code> or something)</p>
  
  <p>Hopefully I've described that accurately.  Any thoughts?</p>
  
  <p><strong>Edit</strong></p>
  
  <p>To be clear, the reason I'm asking is to make sure that my query result contains <em>every</em> column from each table I call even if there are duplicate field names. For example, I might have a table with lots of fields which means I don't want to alias all the fields manually. Further if 3 tables have a field called <code>name</code> my result won't contain three <code>name</code> results; it will have one. <strong>I want to avoid ambiguity</strong> with my column names.</p>