数据库删除字段指定字符前面或者后面的字符串

//查询、删除字段指定字符串后面的字符串
select substr(name,1,instr(name,’#’)-1) from emp where name like ‘%#%’;

update emp set name= substr(name,1,instr(name,’#’)-1) where name like ‘%#%’;

//查询、删除字段指定字符串前面的字符串
select substr(name,instr(name,’#’)+1,length(name)) from emp where name like ‘%#%’;

update emp set name= substr(name,instr(name,’#’)+1,length(name)) where name like ‘%#%’;

注：name:列名，emp:表名，#:指定字符(串)