title: mysql update a column with an int based on order
body: <p>Lets say I have these columns</p>
  
  <pre><code> uniqueID|Money|Quantity|MoneyOrder|QuantityOrder
  1|23|12||
  2|11|9||
  3|99|100||
  </code></pre>
  
  <p>What I want to do is update <code>MoneyOrder</code> and <code>QuantityOrder</code> based on the value of <code>ORDER BY</code>.</p>
  
  <p>So the results would be:</p>
  
  <pre><code>uniqueID|Money|Quantity|MoneyOrder|QuantityOrder
  1|23|12|2|1
  2|11|90|1|2
  3|99|100|3|3
  </code></pre>
  
  <p>I want the update to operate like an identity column without actually making it an identity column.  I know that I could just order by 'x' and the order would be the result but I want to generate a report where you can see the item line by line.</p>
  
  <p>Is something like this possible <code>update mytable set Moneyorder = 'imnotsure' order by MoneyOrder asc</code> ?</p>