title: In MySQL SELECT statement, how can a derived field utilise the value of another field in the SELECT list?
body: <p>In a MySQL SELECT statement, how can a derived field utilise the value of another field in the SELECT list?</p>
  
  <p>For example, when running the following query:</p>
  
  <pre><code>SELECT
   'tim' AS first_name
  ,first_name || ' example' AS full_name;
  </code></pre>
  
  <p>I would expect the result to be:</p>
  
  <pre><code>first_name, full_name
  tim       , tim example
  </code></pre>
  
  <p>Instead, I get the following <strong>error</strong>:</p>
  
  <pre><code>Unknown column 'first_name' in 'field list'.
  </code></pre>
  
  <p>Is there a way I can reference another column?</p>
  
  <p>Thanks<br>
  Turgs</p>