Re: Update query by group

[killer b]

Ok thought that was understandable enouth

Query

SET @temp =0;
UPDATE `jos_bde_10` SET number = @temp := ( @temp +1 );

Query Result

number 	|name 	| class1      
1       John 	 Championship 	
2	David 	 Championship 	
3 	David 	 Clubman	
4 	Chris 	 Clubman  	
5 	Rob 	 Expert 	
6 	Gavin 	 Expert 	
7 	Dean 	 Sportsmen 	
8 	Nicholas Sportsmen

Desired Result

number 	|name 	| class1      
1 	John 	Championship 	
2	David 	Championship
3 	Rob 	Expert
4 	Gavin 	Expert  	
5 	David 	Clubman	
6 	Chris 	Clubman  	
7 	Dean 	Sportsmen 	
8 	Nicholas Sportsmen

Basically need numbers allocated in class1 with the order of Championship, Expert, Clubman, Sportsmen