How to replace rows in a column with new ones with a certain length?

Question

MySQL

there is an items table, there is an item_code column. is a string (varchar), is a certain sequence of numbers.
it is necessary to replace item_code with a short one (last 6 characters) if there are more than 6 characters , that is, 1234567 -> 234567 123456789-> 456789
I can’t understand if this is possible and if so, how? regular expressions to use?

Answer 1

UPDATE `table` SET `field_code` = SUBSTR(`field_code`, -6, 6) WHERE LENGTH(`field_code`) > 6;

Be sure to make a backup before this request , because. in case of an error, the old data cannot be returned ...