protegechris Posted October 6, 2007 Share Posted October 6, 2007 I need to update all the fields that are blank.. table nuke_users, column "user_avatars". I need to set them to say blank.gif rather than just being blank. Anyone care to help me make this query? Quote Link to comment Share on other sites More sharing options...
Barand Posted October 7, 2007 Share Posted October 7, 2007 UPDATE nuke_users SET user_avatars = 'blank.gif' WHERE user_avatars IS NULL Quote Link to comment Share on other sites More sharing options...
fenway Posted October 7, 2007 Share Posted October 7, 2007 Why don't you use a trigger / set a default value? Or better yet, do this in code? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.