title: Confused with UPDATE query. How to convert select to update with MySQL?
body: <p><em>I have seen very similar if not same questions on here but my trials of trying to convert following query into an UPDATE statement failed.</em></p>
  
  <pre><code>SELECT table.* FROM table JOIN (
    SELECT   column, COUNT(*) AS rank
    FROM     table
    GROUP BY column
  ) AS t USING (column) WHERE t.rank = 1
  ORDER BY t.rank DESC
  </code></pre>
  
  <p>I want to update column of all results selected using the query above.</p>
  
  <p>How can I convert this into an update statement? </p>
  
  <p>Thank you.</p>