UPDATE smf_members SET ID_GROUP = '1' WHERE memberName = 'yourusername';