常用的mysql截取函数有：left(), right(), substring(), substring_index() 下面来一一说明一下： 1.左截取left(str, length) [img]http://files.jb51.net/file_images/article/201212/2012120613584431.png[/img] 2.右截取right(str, length) [img]http://files.jb51.net/file_images/article/201212/2012120613584432.png[/img] 3.substring(str, pos); substring(str, pos, len) [img]http://files.jb51.net/file_images/article/201212/2012120613584433.png[/img] 4.substring_index(str,delim,count) [img]http://files.jb51.net/file_images/article/201212/2012120613584434.png[/img]