Simple SQL Script

registered · Regular Joined: Sep 14, 2003 Posts: 74

Hi everyone,

I need to change a value in every user's entry in my SQL database.

I had a problem with the user's avatars which were not being displayed, and I tracked it down to the "nuke_users" table, the "user_avatar_type" which was set to zero (0) and needed to be three (3).

So I manually changed a few via phpmyadmin and everything worked fine. Now I'm left with another 500 users !

Here is the script phpmyadmin came up with for one specific user:

UPDATE `nuke_users` SET `user_theme` = NULL ,
`user_avatar_type` = '3' WHERE `user_id` = '426' LIMIT 1 ;

Now, what I want to do is modify it to include a range of user_id's .. for example from user_id=10 to user_id=100

How would this be possible ?

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Code:

UPDATE nuke_users SET user_theme = NULL , 


user_avatar_type = 3 WHERE user_id > 9 AND user_id < 101;

Posted: Fri Oct 03, 2003 8:28 am

Thanks a million Raven Smile