sql update multi rows - PHP Server Side Scripting forum at WebmasterWorld - WebmasterWorld

Forum Moderators: coopster

Message Too Old, No Replies

sql update multi rows

need help

weddingm

6:08 am on Jul 4, 2013 (gmt 0)

10+ Year Member

I have the following sql code but not working. Please help.

update table set field1='No' where field2='number1, number2, number3';

Thanks,
Matt

jatar_k

6:17 am on Jul 4, 2013 (gmt 0)

WebmasterWorld Administrator

10+ Year Member

update table set field1='No' where field2 in ('number1', 'number2', 'number3');

weddingm

4:59 pm on Jul 4, 2013 (gmt 0)

10+ Year Member

thanks