SQL question - GoFuckYourself.com

Zester · 07-06-2005, 02:40 AM

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

WarChild · 07-06-2005, 02:45 AM

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

07-06-2005, 02:40 AM	#1
Zester Confirmed User Industry Role: Join Date: Jul 2003 Posts: 5,344	SQL question 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 __________________ * Mainstream ? $65 per sale * new male contraception