title: How to alias a field or column in MySQL?
body: <p>I'm trying to do something like this. But I get an unknown column error:</p>
  
  <pre><code>SELECT SUM(field1 + field2) AS col1, col1 + field3 AS col3 from core
  </code></pre>
  
  <p>Basically, I want to just use the alias so that I won't need to perform the operations performed earlier. Is this possible in mysql?</p>