ridesign1 Established Member ★ 20 ★ Impact 7 Jan 16, 2006 1K views 2 replies #1 Hi, I have this query : UPDATE `phpbb_users` SET `user_trade` = NULL , `user_images` = '0' WHERE `user_id` =8 LIMIT 1 ; this changes the user_images to 0, how do I modify this so that it modifies the value to 0 for all users ? thanks
Hi, I have this query : UPDATE `phpbb_users` SET `user_trade` = NULL , `user_images` = '0' WHERE `user_id` =8 LIMIT 1 ; this changes the user_images to 0, how do I modify this so that it modifies the value to 0 for all users ? thanks
axilant Account Closed Impact 28 Jan 16, 2006 #2 UPDATE `phpbb_users` SET `user_trade` = NULL , `user_images` = '0';
ridesign1 Established Member ★ 20 ★ Impact 7 Jan 16, 2006 #3 thanks, didn't realise it would be that simple