NameSilo

Mysql delete query?

Namecheap AuctionsNamecheap Auctions
Namecheap AuctionsNamecheap Auctions
SpaceshipSpaceship
Watch

ridesign1

Established Member
Impact
7
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
 
0
Close
The views expressed on this page by users and staff are their own, not those of NamePros.
GoDaddyGoDaddy
UPDATE `phpbb_users` SET `user_trade` = NULL ,
`user_images` = '0';
 
0
Close
thanks,
didn't realise it would be that simple

:)
 
0
Close
Appraise.net

We're social

Escrow.com
Spaceship
CryptoExchange.com
Domain Recover

NamePros updates

Quick replies: search, your most used replies, and more on every post
Quick replies are easier to find and use now. The quick reply menu has a search box. Type a few letters to find the reply you want. A...
AIVikings
Catchy
  • The sidebar remains visible by scrolling at a speed relative to the page’s height.
Back