Usage of substr function in MySQL and PHP

select VERSION()
select SUBSTRING(cpcode,2) from T_PROVINCE_MATERIAL where province_id=5

In addition, you can use mid(), right(), left(), respectively Take from the right and take from the left.