求个超简单的update语句

[intuition444]

表结构如下：
Audio_id, Album_id
1 -1
2 -1
3 2
4 -1
5 1
6 1
7 3

该表共有两列audio_id, album_id.
需求：
对于aludio_id = 1,2,4,5这四条记录，更新他们的album_id列为4。
请问，如果用一条update 语句，怎么实现？

[jinlingoo1]

update tablename set album_id=4 where aludio_id in (1,2,4)

[JonasFeng]

UPDATE LI 
SET ALBUM_ID = 4
WHERE AUDIO_ID IN (1,2,4,5)

[chuifengde]

update [Table] set Album_id=4 where Audio_id in(1,2,4,5)

[lgx0914]

update biao set album_id=4 where aludio_id in (1,2,4,5)

[jiangshun]

update tb set Album_id=4 where Audio_id in(1,2,4,5)

[winstonbonaparte]

各位速度可真快，楼上几位已经写出答案了，我就不写了

[ks_reny]

[Quote=引用 3 楼 chuifengde 的回复:]
SQL codeupdate [Table] set Album_id=4 where Audio_id in(1,2,4,5)
[/Quote]
速度真快.

[坚强的豁着]

UPDATE LI 
SET ALBUM_ID = 4
WHERE AUDIO_ID IN (1,2,4,5)

[hui_hui_2007]

id in (1,2,4,5)
这个最简单了。

[xinzaitian002]

百花齐放！

[s1ss1s]

update tablename set album_id =4 where audio_id in (1,2,4)

[donghuizhang]

update tablename set album_id=4 where aludio_id in (1,2,4,5)

[jeansy911]

create table aa
(Audio_id int,Album_id int)
insert into aa
select 1,-1 
union all
select 2,-1 
union all
select 3,2
union all 
select 4,-1
union all 
select 5,1
union all 
select 6,1
union all 
select 7,3 

update aa
set Album_id=4 where  Audio_id in(1,2,4,5)
-------------------------------------------
Audio_id  Album_id
1         4
2         4
3         2 
4         4
5         4
6         1
7         3

[lostbarque]

update tb set album_id=4 where aludio_id in (1,2,4,5)

[gw0702]

update #tb case when audio_id=1 then set album_id=4 end
case when audio_id=2 then set album_id=4 end
case when audio_id=4 then set album_id=4 end
case when audio_id=5 then set album_id=4 end

[数字化从业者老高]

update tablename 
set album_id=4 
where aludio_id in (1,2,4,5)

[feixianxxx]

--如果是aludio_id字符型的话
update tablename 
set album_id=4 
where charindex(','+ltrim(aludio_id)+',','1,2,4,5')>0

[Jamin_Liu]

update tablename set album_id=4 where aludio_id in (1,2,4,5)

[springforxsh]

差不多就是这些了，楼主怎么还不给分啊~~~