求一句sql!

[firefox_1983]

<FONT face=Arial size=2><STRONG><IMG height=220 src="http://www.ep365.com/english/gl/upload/2006215105416184.jpg" width=300 align=right border=0>The best dive trips, liveaboards, resorts, and tours in Australia are represented here in the On-line Australia
.............
上边是表中一个字段中的一条记录，每条记录格式相同。先要把'www.ep365.com'更换成'localhost',如何写sql?

[子陌红尘]

update 表 set 字段=replace(字段,'www.ep365.com','localhost')

[lsqkeke]

update 表名 set colname=replace(colname,'www.ep365.com','localhost')

[xeqtr1982]

replace(字段,'www.ep365.com','localhost')

[xeqtr1982]

update yourtable set 字段=replace(字段,'www.ep365.com','localhost')