title: UPDATE column using a result from SELECT subquery
body: <p>This query returns an error : "Subquery returns more than one row":</p>
  
  <pre><code>UPDATE forums as f 
  SET f.f_last_pid = (SELECT pid FROM  posts ORDER BY  ptime DESC )
  </code></pre>
  
  <p>I know that i need to use <code>ANY</code> before the subquery but that won't get the proper result I want. I want to update every row in my forums table based on the result shown from the subquery.</p>