change id_group SQL

[dominioboys]

in my phpmyadmin many users have id_group of 0 when they should be 13 and 32 which should be 13 (id_group) how can I run a SQL query to set them all the same?

[Illori]

why do you believe the group is wrong? what is group 13 and 32?

[Shambles]

http://www.mysqltutorial.org/mysql-update-data.aspx

[dominioboys]

the right group is 13 and therefore whoever has 0 and 32 must set you to 13

[Illori]

you are still not telling us why 0 and 32 are wrong and why 13 is right. also you are not telling us what those groups represent. it may be setup this way for a reason but without details we cannot tell you how to fix it correctly.

[dominioboys]

group 13 and the right one linked to the rank of menbro in the forum.  while group 32 does not exist in the forum script and therefore I have to change them because those with the value 0 and 32 cannot read the messages and are not allowed to open new topics and then to an id that does not exist in the db for that  I want to change them to the right group of members

[Illori]

is group 13 a post count based group?

if 32 does not exist then it should not have any users assigned to that group.

[dominioboys]

group 13 is the main one for members and I would like it to be updated to that group

[dominioboys]

solved with this mod
http://custom.simplemachines.org/mods/index.php?mod=3104