I have this table:

```
  ID   |  Name  | GroupORDER |
  1    |  John  |    1       |
  2    |   Ben  |    2       |
  3    |   Joe  |    2       |
  4    |  Paul  |    2       |
  5    |  Anna  |    2       |
  6    |  Tash  |    3       |
  7    |  Ryan  |    3       |    

```

I d like to swap with one query the GroupORDER between two groups and have this result:

```
  ID   |  Name  | GroupORDER |
  1    |  John  |    1       |
  6    |  Tash  |    2       |
  7    |  Ryan  |    2       |  
  2    |   Ben  |    3       |
  3    |   Joe  |    3       |
  4    |  Paul  |    3       |
  5    |  Anna  |    3       |

```

Any Ideas?
Something like this totally wrong query:

```
 UPDATE table SET GroupORDER = 2 
 WHERE GroupORDER = 3 AND GroupORDER = 3 WHERE GroupORDER = 2;

```

I am trying to make happen it with one query