title: How to overwrite values during a select query in sql?
body: <p>Suppose I have a table foo with schema (name, age). So the table looks like:</p>
  
  <pre><code>NAME | AGE
  John | 20
  Jane | 50
  Jason | 30
  </code></pre>
  
  <p>Now suppose I wanted to select from this table, but I wanted to change all their ages to 20 via the select query. That is, I don't want to update the original table foo, but I want to select, something like:</p>
  
  <pre><code>SELECT name, 20 as age from foo
  </code></pre>
  
  <p>In other words, I want to manipulate the data on the select. Of course, my real-life example is much more complicated than this but knowing the answer to this will do. Thanks!</p>