Welcome to WebmasterWorld Guest from 54.224.63.26

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

sql update multi rows

need help

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

Junior Member

10+ Year Member

joined:Mar 9, 2006
posts: 177
votes: 0


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 July 4, 2013 (gmt 0)

Administrator

WebmasterWorld Administrator jatar_k is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:July 24, 2001
posts: 15755
votes: 0


update table set field1='No' where field2 in ('number1', 'number2', 'number3');
4:59 pm on July 4, 2013 (gmt 0)

Junior Member

10+ Year Member

joined:Mar 9, 2006
posts: 177
votes: 0


thanks