Welcome to WebmasterWorld Guest from 23.22.46.195

Forum Moderators: coopster & jatar k

sql update multi rows

need help

   
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
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');
4:59 pm on Jul 4, 2013 (gmt 0)

5+ Year Member



thanks
 

Featured Threads

My Threads

Hot Threads This Week

Hot Threads This Month