Posted by Joe Makowiec on 11/02/05 12:37

On 02 Nov 2005 in alt.php.sql, 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.

http://dev.mysql.com/doc/refman/4.1/en/update.html

--
Joe Makowiec
http://makowiec.org/
Email: http://makowiec.org/contact/?Joe

[Back to original message]