title: MySQL: alias column name question
body: <p>Is it possible to alias a column name with the result of a simple SELECT query.</p>
  
  <p>This doesn't work: </p>
  
  <pre><code>SELECT `hlevel1` AS (SELECT `level1` FROM `hierarchy_labels` LIMIT 1) FROM `hierarchy`;
  </code></pre>
  
  <p>Any Suggestions?</p>