title: Concatenate strings to specify field name
body: <p>Using MS SQL Server but porting on MySQL so I need a solution for both ideally (but MySQL preferably)</p>
  
  <p>I am trying to concatenate two field in order to specify the field name for the select statement.</p>
  
  <p>Example table:</p>
  
  <pre><code>id     | name
  1      | John
  2      | Bob
  
  
  SELECT id, 'na'+'me' as value FROM table WHERE 1=1
  </code></pre>
  
  <p>actual return (of course)</p>
  
  <pre><code>id     | value
  1      | name
  2      | name
  </code></pre>
  
  <p>expected return:</p>
  
  <pre><code>id     | value
  1      | John
  2      | Bob
  </code></pre>
  
  <p>I have no clue as to how to specify that the concatenate result is to be used as field name, and not as result.</p>