场景
有时候我们在处理字符串的时候可能不是拿来就用难免需要做一些操作,比如拼接用户地址(国家、省市、区县等),展示文章简介的千30个字等
语法
left(column, n) 截取column的前n个字符substring(column, start, lenth) 从start开始截取lenth个,这里从0开始concat(s1, s2, s3...) 连接字符串
使用
select * from article where id = 1;+----+-------------+-------------------------------------------------------------------+| id | title | content |+----+-------------+-------------------------------------------------------------------+| 1 | MySQL优化 | 我们来讲一讲MySQL优化,分几个方面讲,第一是表 |+----+-------------+-------------------------------------------------------------------+1 row in set (0.00 sec)select substring(content, 1, 10) from article where id = 1;+---------------------------+| substring(content, 1, 10) |+---------------------------+| 我们来讲一讲MySQ |+---------------------------+1 row in set (0.00 sec)select left(content, 10) from article where id = 1;+------------------------+| left(content, 10) |+------------------------+| 我们来讲一讲MySQ |+------------------------+1 row in set (0.01 sec)
来看一个concat的例子
select * from address where id =1;+----+---------+--------+-------------------------+| id | country | city | detail |+----+---------+--------+-------------------------+| 1 | 中国 | 北京 | 丰台区铁营里12号 |+----+---------+--------+-------------------------+1 row in set (0.00 sec)select concat(country, city, detail) from address where id = 1;+-------------------------------------+| concat(country, city, detail) |+-------------------------------------+| 中国北京丰台区铁营里12号 |+-------------------------------------+1 row in set (0.00 sec)