T touchme_1 Unregistered / Unconfirmed GUEST, unregistred user! 2000-11-11 #1 在表中某个字段的记录有zh0101,zh0102,zh010201...,反正前四位是zh01， 能否通过一个SQL语句，将前四位都改为zh02？谢谢！
H hhzh426 Unregistered / Unconfirmed GUEST, unregistred user! 2000-11-11 #2 update table1 set field1=replace(field1,"zh01","zh02")
P plowboy Unregistered / Unconfirmed GUEST, unregistred user! 2000-11-11 #4 update table set field='zh02' + substring(field,5,1000) where ...
L lccc Unregistered / Unconfirmed GUEST, unregistred user! 2000-11-12 #6 hhzh426 的方法将使诸如“zh01*zho1”也改掉，同意plowboy的方法。 补上 WHERE 子句供参考： WHERE substring(field,1,4)="zh01"
