Return updated row attributes on UPDATE
<p>My query is as follow:</p>

<pre><code>UPDATE t1 SET t1.foreign_key = (SELECT id FROM t2 WHERE t2.col = %s ) 
WHERE t1.col = %s
</code></pre>

<p>How do I return some attributes of the updated row in the table in the same query?</p>