Posted by Rik on 11/02/05 12:35
sittingduck wrote:
> Using phpMyAdmin, I want to find every user in my nuke_users table
> that has user_timezone -7 (figured this part out) and CHANGE the
> value to -8. (can't find a way to do this part)
>
> How can I do this? there are about 60 users that still have -7, and
> editing them one at a time would be a PITA.
run SQL:
UPDATE nuke_users SET user_timezone=-8 WHERE user_timezone=-7
Grtz,
Rik
Navigation:
[Reply to this message]
|