2.5g:0.1g(10万单位) ->2.5g:0.1g
update titles set title = replace(title, substring(title, locate(’(’, title),locate(‘单位)’, title)+3-locate(’(’, title)),’’);
2.5g:0.1g(10万单位) ->2.5g:0.1g
update titles set title = replace(title, substring(title, locate(’(’, title),locate(‘单位)’, title)+3-locate(’(’, title)),’’);