sql update multi rows

need help

[weddingm]

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]

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

[weddingm]

thanks