MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table doc_properties
(
    id int not null,
    doc_property_category int,
    prop_id int,
    value text
);
insert into doc_properties values
(1, 1, 1, '0200s'),
(2, 1, 1, '1200s'),
(3, 1, 1, '0500s'),
(4, 1, 1, '1900s');
update doc_properties
set value = concat(lpad(cast(left(value, 4) as signed) + 100, 4, '0'), 's')
where substr(value, 1, 1) between '0' and '9';
select * from doc_properties;


id
doc_property_category
prop_id
value


1
1
1
0300s

2
1
1
1300s

3
1
1
0600s

4
1
1
2000s