mysql复习第二天：单行函数

1、常用字符函数

• 查看字节编码

SHOW VARIABLES LIKE '%char%';

• 获取字符串的自己长度

SELECT LENGTH('我是卫卫) AS a,LENGTH('111') AS b;

• UPPER：将字符串转成大写，LOWER：将字符串转成小写

SELECT UPPER('aaa') AS a,LOWER('AAA') AS b;

• substr 截取从指定索引后的字符串(mysql是从1开始)

SELECT SUBSTR('123456789',2) AS a;

• substr 截取从指定索引处制定长度的字符串

SELECT SUBSTR('123456789',);

• instr返回子串第一次出现的问题,找不到返回0

SELECT SUBSTR('123456789',1,4) AS a;

• trim去除前后指定字符串,默认去除前后空格

SELECT LENGTH(TRIM('  12343  '));
SELECT TRIM('a' FROM 'aaaaa12345aaaa') AS a;

• lpad用指定字符实现左填充制定长度

SELECT LPAD('1234',10,'*') AS a;

• rpad用指定字符实现右填充制定长度

SELECT RPAD('1234',10,'*') AS a;

• replace 替换

SELECT REPLACE('1213141','1','2') AS a;