Substr in MySQL and PHP

Substr: String truncation function. Substr ($ str, $ start, $ end)

If the substr function in MySQL needs to be truncated from the first character, the first parameter should be 1;

If the substr function in PHP needs to be truncated from the first character, the first parameter should be 0;

Note: MySQL 5.x supports substr. If MySQL is 4.x, you can use left ($ str, $ length)

Mysql 5.x => substr ("abc", 1, 1) =

Mysql 4.x => left ("abc", 1) =

PHP => substr ("abc", 0, 1) =

PS: View MySQL VERSION: select VERSION ()

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

Mid is also OK

There are also right (), left (), can be, respectively from the right and from the left