SQL update 更新字段内的字符串

Question

我想把asset_cehuixianlu这个表里的pot字段内的YYKXXX+XXX替换为YKXXX+XXX，X为不确定数字，有数十万条数据，求大神指教

Answer 1

MBKOXADSIEHIEHKAPWTCFIAVRHDGPSUVLTJEBEAJMGCFTIRBJTCFOQZPYADMPYTDMWRTQGVJGPYBRKZIGVYBXAQDQEAJZCLUXGJOKTWSURNIEHWTJSBRHWMNJUQZJFOKZJYIEAWLVEUQTJFFBKUEUJFPSCTCLUQTWLVFVWRNCFBDZCYGRAIRHJSBDGOTIKTIEAIKUKTIYIXGPLUCMWLUDFPLBDMVJFAQSHWFUQMJDYOQGILNJYOKFIEMPEAXMOXTQMOQFIRGYTISODYBQTPAWRPLAWSVLUZCXUCSUXTVYYNJLUCFCYBXRZPFHWMUDNQEAWZCJMCEAQEZORAWMVDMPFOPENJLOKTWNWEAWRAPLCYWSUDZVLLAXZEZAWGJYHWGILHPSUYVRNPEBDGCYNKGBYNLFBDAQHQLUDNHXAPSUWMJLIERUJZVRTJYLAXGWYUKTCRPKNJSBXMILILACFAEMIYPLFHDMPEZILVCGPEHQBQSHLNKGCEAPYUWMIVRTCRUKTNDLBJZBJSUWZVXIXGPYHKZVRNENPLUYHDSBWAPRFOKOXMVRILGRMJSBDGHCEMCEFOKZJYXTDFIEGBDMPSTPLADFIEGCQFBXGCFTCFCRTCSBQAWSNXQGVKGCLOXTCZBXMNPLAJZOOQFIXNIRHKGRTVZOEGXGDFHPFCMCLNDNOPFUDAPFHXAQQSBXADMKGWRRUQHJMPDMPYSOQGJGQMWMHNXZWMCYACFORAJMVENJYBYHJSOKGJLBXZDFOKTVRUWZVMBJRTPLUDMPRNVLUXGBQTIRZIRGJXTVYNXGIKNJMAJSVQMBKTJFHQLVIXMPYORHWMCJLVWSOYBQBKKZCXTQGCROLOQUQGCSUEAQPZULAQMPQMK

Answer 2

插眼。

Answer 3

写个程序，批量更新

Answer 4

是去掉一个Y么？