Quote:
|
Originally Posted by Zester
what is wrong with this sql?
Code:
update `customers` set payout=100 where id=('234', '34', '102');
what i'm trying to do is set the payout to 100 to customers which ID is either 234, 34 or 102 in the shortest sql possible |
UPDATE customers
SET payout = '100'
WHERE id IN ('234', '34', '102');