artharry shares
update a set b=concat(substr(b,3,(char_length(
-3)),substr(b,1,2)); The first two characters move to the back of the words #sql update a set b=concat(substr(b,3,(char_length(-3)),substr(b,1,2)); The first two characters move to the back of the words #sql