SQL question

[Zester]

what is wrong with this sql?

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

[WarChild]

what is wrong with this sql?

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');