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? Link to comment https://forums.phpfreaks.com/topic/72132-updating-all-blank-fields/ 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 Link to comment https://forums.phpfreaks.com/topic/72132-updating-all-blank-fields/#findComment-363903 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? Link to comment https://forums.phpfreaks.com/topic/72132-updating-all-blank-fields/#findComment-364032 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.