Home  >  Article  >  Database  >  mysql截取函数常用方法使用说明

mysql截取函数常用方法使用说明

WBOY
WBOYOriginal
2016-06-07 17:55:061018browse

常用的mysql截取函数有:left(), right(), substring(), substring_index(),很多新手朋友不是很了解,接下来详细说明,需要的朋友可以参考下

常用的mysql截取函数有:left(), right(), substring(), substring_index()

下面来一一说明一下:

1.左截取left(str, length)

2.右截取right(str, length)

3.substring(str, pos); substring(str, pos, len)

4.substring_index(str,delim,count)

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