title: Update field if the ORDER BY is 1 descending?
body: <p>Is there a possible way to do this: </p>
  
  <p>I want to update a field 'rank' according to the ORDER BY place. </p>
  
  <p>For example: (pseudocode)</p>
  
  <pre><code>If id order by place = 1 then update rank field to place were id=get id
  
  
   rank place id
  
    1     1    5   PC
    2     2    8   MAC
  </code></pre>
  
  <p>is this possible? </p>