无题

update action_c_clob set largeinput=ltrim(substr(largeinput,instr(largeinput,'@#$%%%%%',1,1)+9,length(largeinput)-instr(largeinput,'@#$%%%%%',1,1)-9))
where action_id=8

update action_c_clob set largeinput=ltrim(substr(largeinput,2,length(largeinput)-1)) where action_id=8
【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/danghuijian/p/4400566.html