1.修改某个字符串字段中一部分的内容:
update t_xxx set f_xxx=replace(f_xxx,'微软雅黑','宋体');
2.在大字段中查找某字符串是否存在:
select * from t_XXX where instr(F_XXX, 'XXX') > 0;
select * from t_XXX where instr(F_XXX, 'XXX') = 0;
1.修改某个字符串字段中一部分的内容:
update t_xxx set f_xxx=replace(f_xxx,'微软雅黑','宋体');
2.在大字段中查找某字符串是否存在:
select * from t_XXX where instr(F_XXX, 'XXX') > 0;
select * from t_XXX where instr(F_XXX, 'XXX') = 0;