title: Is it possible to dynamically select a column name in MYSQL where the column name is 1 of N known values?
body: <p>I fear the answer will be a straight 'no', but I was wondering if it's possible to do something such as the following in MySQL:</p>
  
  <p><code>SELECT (title||label||name) FROM table</code></p>
  
  <p>i.e Select a single column, which may be called <code>title</code>, <code>label</code> or <code>name</code>, from <code>table</code>.</p>
  
  <p>Reason being: the query will be dynamically generated where <code>table</code> is known but (due to reasons beyond my control) there is no consistent naming convention in the other tables.</p>