想实现的功能如下
update jfsky.product set support=Regexp_replace(support,')SINGLE',') SINGLE')
where instr(Support,')SINGLE')>0
提示括号不匹配,把')SINGLE'改成'')SINGLE',提示未正常结束,改成
update jfsky.product set support=Regexp_replace(support,''')SINGLE',''') SINGLE')
where instr(Support,''')SINGLE')>0
语句可以执行但不起作用,只是运行了,没有修改数据
期盼大侠出现
update jfsky.product set support=Regexp_replace(support,')SINGLE',') SINGLE')
where instr(Support,')SINGLE')>0
提示括号不匹配,把')SINGLE'改成'')SINGLE',提示未正常结束,改成
update jfsky.product set support=Regexp_replace(support,''')SINGLE',''') SINGLE')
where instr(Support,''')SINGLE')>0
语句可以执行但不起作用,只是运行了,没有修改数据
期盼大侠出现
------------------------------
SINGLE1111SQL>