HELP: mass change user's timezone

[khaleejy]

hi

I want to change all users who have set their timezone: 0 i want to change it to: +3

is their any simple command that replace all "0" with "+3" in user's timezone??

[Logician]

update user set timezoneoffset='+3' WHERE timezoneoffset='0';

Backup your db first!