title: MySQL concat() to create column names to be used in a query?
body: <p>I would like to concatenate column names in a way that the first part of the column name is a string and the second part is a number which is the result of another query.</p>
  
  <p>For example:</p>
  
  <pre><code>SELECT CONCAT('column', mytable.mycolumn) FROM table ...
  </code></pre>
  
  <p>Can this be done in some way. This way it doesn't give me errors but I don't get the expected result and it seems the concatenation doesn't work.</p>