Log in

View Full Version : query help please

Night Owl
11-25-2002, 01:15 AM
I need a query I can run through phpmyadmin, that will move everyone with "0" posts from usergroup 21 to usergroup 2. Can someone show me the proper syntax for that?

Thank you!
JulianD
11-25-2002, 01:42 AM
UPDATE user SET usergroupid='2' WHERE posts='0'
Xenon
11-25-2002, 02:13 PM
not exact:
UPDATE user SET usergroupid='2' WHERE posts='0' AND usergroupid=2

that's the correct way
tHE DSS
11-25-2002, 04:31 PM
Originally posted by Xenon
not exact:
UPDATE user SET usergroupid='2' WHERE posts='0' AND usergroupid=2

that's the correct way


... or is it :

UPDATE user SET usergroupid='2' WHERE posts='0' AND usergroupid=21
Erwin
11-25-2002, 07:54 PM
tHE DSS wins the prize! ;)
Night Owl
11-25-2002, 07:59 PM
:laugh: Thank you all for your responses!
Xenon
11-25-2002, 08:02 PM
damn, i'm too fast in typing... ;)