GoFuckYourself.com - Adult Webmaster Forum - View Single Post

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

07-06-2005, 02:40 AM
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