How to add 100 to all strings starting with a digit in an attribute
It assumes that value field length is always 5 and s is located always at end of the string.




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



db&lt;>fiddle here