_________
MySQL 字符串截取函数；
标签：bsp lap pen open last dex logs blog mysql
MySQL 字符串截取函数；
mysql> select left(‘example.com‘, 3);
+-------------------------+
| left(‘example.com‘, 3) |
+-------------------------+
| exa |
+-------------------------+
2. 字符串截取：right(str, length)
mysql> select right(‘example.com‘, 3);
+--------------------------+
| right(‘example.com‘, 3) |
+--------------------------+
| com |
+--------------------------+
//从一个字段取后两位字符更新到另外一个字段
update `historydata` set `last2`=right(last3, 2);
View Code