update table set column = value where column in (conditional values);


update table set column = value where column not in (conditional values);