title: MySQL reuse virtual row
body: <p>Let's say I have a simple table of:</p>
  
  <pre><code>id,name,salary
  </code></pre>
  
  <p>The query I have is:</p>
  
  <pre><code>SELECT id,
         name,
         (salary+1) as MS
  FROM test_table
  </code></pre>
  
  <p>The query I would like is:</p>
  
  <pre><code>SELECT id,
         name,
         (salary+1) as MS,
         (MS-20) as MS2
  FROM test_table
  </code></pre>
  
  <p>Is that possible in any way or is the only option to make new subquery every time I need to get MS value?</p>