MySQL UPDATE with GROUP and ORDER
<p>I'm trying to make an update on a table so that it can increment the values on 1 column depending on another's order. 
Here's how it'd go</p>

<pre><code> ID    GROUP_ID    ORDER(Desired)   ORDER(NOW)
 1        1             1              2
 2        1             2              3
 3        1             3              1
 4        2             1              2
 5        2             2              1
 6        3             1              1
 7        3             2              1
 8        3             3              2
</code></pre>

<p>So what I need is for each ID, to update the ORDER column so it can be consecutive, starting from 1, within each GROUP_ID.</p>

<p>I have found some solutions to similar problems regarding the updates and orders, but none that uses multiple orders for groups within the same table.</p>

<p>Hope I illustrated the problem right. Thanks in advance</p>