search

Home  >  Article  >  Backend Development  >  Usage of substr function in MySQL and PHP

Usage of substr function in MySQL and PHP

WBOY
WBOYOriginal
2016-07-25 08:55:01974browse
  2. select VERSION()
  3. select SUBSTRING(cpcode,2) from T_PROVINCE_MATERIAL where province_id=5
Copy code

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



Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：php import csv to mysql databaseNext article：php import csv to mysql database

Related articles

See more