Simple query needed

[RichieBoy67]

I would like run a query to change my usergroup "users waiting for e-mail confirmation" into registered members..

I have been trying and having no luck. Can someone help out please???


Thanks