mysql query

[Nightimarez]

I need a query for mysql that updates the player vocation.

If groupid 2, then set vocation to 2.

It's probably something like this but I can't get it right.

UPDATE players WHERE group_id=1,SET vocation=1;

i still can't get it right..

 

[Cykotitan]

UPDATE `players` SET `vocation` = 2 WHERE `group_id` = 2;