简单但有用的 SQL-L替换

将字段中指定的字符替换成别的字符:

 select 字段1=replace(字段1,'x','y') from table1 where ID=106

将字段1中原来的字母x全部替换成y,更新类似:

更新:

update table1
set 字段1=replace(字段1,'x','y')
where ID=106

 

删除重复记录:

delete table1 from table1 as a
where id>
(SELECT min(ID) from table1 where AuthenID = a.AuthenID
 and Standard=a.Standard)