Welcome to WebmasterWorld Guest from 54.226.62.26

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

sql update multi rows

need help

     

weddingm

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

5+ 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 jatar_k is a WebmasterWorld Top Contributor of All Time 10+ Year Member



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

weddingm

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

5+ Year Member



thanks
 

Featured Threads

Hot Threads This Week

Hot Threads This Month