<p>If I've got a table containing Field1 and Field2 can I generate a new field in the select statement? For example, a normal query would be:</p>

<pre><code>SELECT Field1, Field2 FROM Table 
</code></pre>

<p>And I want to also create Field3 and have that returned in the resultset... something along the lines of this would be ideal:</p>

<pre><code>SELECT Field1, Field2, Field3 = 'Value' FROM Table
</code></pre>

<p>Is this possible at all?</p>

[{'answer_id': 38942, 'author': 'Josh', 'author_id': 257, 'author_profile': 'https://Stackoverflow.com/users/257', 'pm_score': 5, 'selected': True, 'text': "<pre><code>SELECT Field1, Field2, 'Value' Field3 FROM Table\n</code></pre>\n\n<p>or for clarity</p>\n\n<pre><code>SELECT Field1, Field2, 'Value' AS Field3 FROM Table\n</code></pre>\n"}, {'answer_id': 38944, 'author': 'Whisk', 'author_id': 908, 'author_profile': 'https://Stackoverflow.com/users/908', 'pm_score': 3, 'selected': False, 'text': "<p>Yes - it's very possible, in fact you almost had it!\nTry:</p>\n\n<pre><code>SELECT Field1, Field2, 'Value' AS `Field3` FROM Table\n</code></pre>\n"}]
['https://Stackoverflow.com/questions/38940', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/393028/']